Migrate mysql server

[princelindie]

How do I migrate (copy) mysql database to another server/machine.

[randome]

Hi,
use mysqldump command

[Markus]

If you are using phpmyadmin, you can go to any table you have created and then use the 'export' link at the top.

Make sure SQL is checked in the next page you come to, and then carry on.
It will give you a load of code; copy this and then go to your new servers phpmyadmin.

Open up the 'SQL' tab and then paste the code into the textarea.

Query it, and you're done!

But then again, if you're not using phpmyadmin (shock) this isn't very helpful :P