Problem:
How to Export and then Import a MySQL database using PhpMyADMINSolution:
The following are the steps to Export and then Import a MySQL database usnig 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 .Select structure and data to backup the whole table/ database. Select data only if you only want to back up data. You can click the 'Export' button at any time, but if you want to back up the entire database, then you must be at the database structure page and click the export button
- Ensure you choose SQL as the option (this will alow you to just paste the SQL for your remote server)
- 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 to phpMyAdmin
- Open cPanel and open your phpMyAdmin on your remote server.
- 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.
