How to backup a MYSQL database using phpmyadmin
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.
- Step 2
Click on the export tab as seen below
Step 3
You then need to tick Add DROP TABLE / VIEW / PROCEDURE / FUNCTION as seen below
- 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.