RE: Newbie Q - Re: Copying databases

2005-04-29 Thread mathias fatene
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]

RE: Newbie Q - Re: Copying databases

2005-04-29 Thread [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