How to Backup and Restore your MySQL Database using phpMyAdmin
The following are the steps to Export and then Import a MySQL database using phpMyAdmin
Export from phpMyAdmin
- Open cPanel and open your phpMyAdmin
- On the welcome screen you will see an Export option click on this link
- This will bring up the view dump (schema) of databases screen
- Select the tables you wish to be exported from the list
- Ensure you choose SQL as the option (this will allow you to just paste the SQL for your next host)
- It will create text file on the screen, highlight the information and paste it into a text document.
Save this for when you get hosting.
Import into phpMyAdmin
- Open cPanel and open your phpMyAdmin
- On the welcome screen you will see an Query window option (lower left corner) click on this link
- Paste the contents of the text file that you exported and done. Your database and it's contents are moved
Notes
There are two limitations on importing data into phpMyAdmin...- PHP file upload size limits on uploading the file (default is 2Mb)
- Post size limits, as defined by both your browser and the server (default is 4Mb)
Keep hold of the file so that you have a backup to refer to should something go wrong with the import.
