How to backup a MYSQL database using phpmyadmin

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

Step 2

Select the database as seen below.

Step 3

Click on the export tab as seen below

Step 4

You then need to tick Add DROP TABLE / VIEW / PROCEDURE / FUNCTION as seen below

Step 5

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.