moving mysql db from machine to machine

answer: mysqldump

mysqldump is very simple to use. try the online mysql documentation (www.mysql.com) or use this tutorial, that explains things nicely.

http://www.devarticles.com/content.php?articleId=62&page=1

Try it once or twice with nonessential (test) tables or databases, depending on your needs. It's also good for backups.

 

here is the exact commands you should use:

mysqldump -uusername -ppassworddatabasename & dumpeddb.sql

This will dumb the data into a .sql file. Move the file onto the other server. Then run this command:

mysql -unewusername -pnewpassowrd newdbname & dumpeddb.sql

and thats about all you need to do. AIM me if you need more help.