How to export/import databases in Cpanel 11 correctly?

[andreyknure]

Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how should I act with my ready databases if I have Cpanel 11 installed? I don't wish to rewrite them again and just would like to move them from local host to hosting!

[ldcdc]

While I haven't done it in this fashion before (had no need to with phpmyadmin always available), you could do a mysql dump (http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html) on the localhost and a restore on the new server. The restore should be doable via phpmyadmin, or you could also ask your host (or rather your friend's host) to do the restore for you.

[andreyknure]

The situation is the following I used phpmyadmin 2.11.5 on localhost when creating databases, but I have phpmyadmin 2.11.6 installed on my hosting account. I am planning to upload databases to hosting really soon and I have some questions about uploading databases to hosting. Can phpmyadmin version difference cause any problems when importing databases to hosting account?

[ldcdc]

I don't suppose there will be issues. Nothing is 100% sure though.

[hexahost]

In your localhost you will have your shell access right ? Use mysqldump to export database to a .sql file and use this file to import database using phpmyadmin. This should work for all versions.

[mwaraitch]

You can simply login to your cpanel, and goto phpmyadmin and import your database .sql file into it, thats it, The newer version does not matters, while if you have old one then there might be a problem,