How to backup a MYSQL database using phpmyadmin

From Imaginet FAQ
Jump to navigation Jump to search

Its very important that you know how to make a backup of your websites database if you are going to make regular changes to your website.

  • Step 1
Login to http://phpmyadmin.yourdomain.co.za and select the database as seen below.
Database imag2.PNG
  • Step 2
Click on the export tab as seen below
Database imag3.PNG

Step 3

You then need to tick Add DROP TABLE / VIEW / PROCEDURE / FUNCTION as seen below
Database imag4.PNG
  • Step 4
Make sure that you select "Save as file" and click on the "Go" button, you will then be asked to save the SQL file and that's it, you now have a backup of your database.
Database imag5.PNG