exporting database/tables to remote computer

[black_lotus]

Hi, I just wanted to know how I can export a database and its tables to a remote computer that also has MySQL. I was thinking I can just ftp the data/database folder to the right location. This will include the files that MySQL uses(.frm, .MYD, .MYI). Would this create other issues though?

Thanks

[Dylan Leblanc]

The thing with databases is that they are supposed to make your data completely transferable to another system, and easily. That's what SQL is for - use mysqldump, http://www.mysql.com/doc/en/mysqldump.html

Directly copying the MySQL files might work, but you're not supposed to do it that way.