Moving a MySQL DB to another server?

[Anon]

Just wondering if it was possible to transport an established database from a MySQL installation on one server to a second installation on another server. It would be nice if I didn't have to completely re-create and re-populat an established DB!

Thanks in advance!

[Anon]

The way I know is:

mysqldump YOUR_DATABASE > your_database.txt

copy your_database.txt to the new server and... then...

mysql YOUR_DATABASE < your_database.txt

And that's it!.