Copying a MySQL database from a different server running cpanel?

[Dragons Master]

Heya Folks,

I'm migrating into a new server running plesk and I've got HUGE forums I mean the database size is over 200mb gzipped! so question is basically if I can use the migration manager or if there's anyway to copy a certain mysql database from the old server who ran cPanel to the new one?

If so, please let me know how to do it.

Thanks a bunch,
- Ben

 

[hardweb]

Dump the database in SQL format in command line on the old server and restore in on the new server in shell. The database size does not matter.

 

[Dragons Master]

What are the commands?

Sorry but I never done such a thing? I know how to work with shell but I don't know the commands..

Can you please let me know the command to dumping the database into a file and the command to restoring a database from a file.. I guess all I need is these 2 commands and of course the wget command to transfer the file =)

Thank you!