Re: Move database to a new machine

[Peter Brawley]

A MySQL database isn't a file. It's an object created & maintained by the MySQL RDBMS.

Simplest way to copy the db from your desktop instance of MySQL with mysqldump ...

mysqldump -uUSR -pPWD db -K -E -R >db.sql

... where USR & PWD are your MySQL username & passowrd, then import that file of SQL cmds into your MySQL server instance with the source cmd in that instance's mysql client program running on the server, eg ...

source path_to_db_sql (no terminating semicolon)