The following are the steps to Export and then Import a MySQL database usnig phpMyAdmin

Export from phpMyAdmin


1. Open cPanel and open your phpMyAdmin
2. On the welcome screen you will see an Export option click on this link
3. This will bring up the view dump (schema) of databases screen
4. Select the tables you wish to be exported from the list
5. Ensure you choose SQL as the option (this will alow you to just paste the SQL for your next host)
6. 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


1. Open cPanel and open your phpMyAdmin
2. On the welcome screen you will see an Query window option (lower left corner) click on this link
3. Paste the contents of the text file that you exported and done. Your database and it's contents are moved.