Mysql Data Backup & Restore Problem

[JaiSoni]

Hi
I m newbie with mysql i m trying to make a copy of mysql database to cd drive and then restore this one to another machine, but i m getting problem
and i dont know the way to perform this task.
I use mysqlhotcopy and mysqldump programs but mysql> give an error message saying that you have an error with your syntex, here is the code line i m doing

mysql> mysqlhotcopy km c:\kmdata

here km is my database name and c:\kmdata is the path for new dir.

Please help me how can i perform my task.

[IlyaDevyatovsky]

Hi,

Try to use this line:

mysqldump --opt -u USERNAME -p PASSWORD DATABASE > backup.sql

Then move the backup.sql to a CD.