http://dev.mysql.com/doc/mysql/en/backup.html
It's better to backup with tools. You will be sure that tables are
FULL-locked.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: [EMAIL PROTECTED]
Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bingt;mysql -uroot db2 lt; test1.txtERROR 1064 at line
54: You have an error in your SQL