Hi all,
Today am going to show you all on how to move databases from your
localhost to your online host or from one host to another, just the same thing....i don't have much time now, let me just cut it short
- Launch your localhost and click on the database you want to move am using test to test this tutorial
- I created a table named testing2, now not clicking on the table...i want to export the database, all i have to do is click on export
- Now the next page you'll see is Exporting tables in database name, then click on go and download the .sql file
- Now we all know that we have PHPMyAdmin in your Cpanel too, login to it and create a database, click on the database to open (Am using test to restore the database)
- Browse out where you saved the .sql file and upload, then click go
Congratulations! your database has been imported...that all!

THE SAME THING IS APPLICABLE IN MOVING MYSQL DATABASE FROM ONE HOST TO ANOTHER