Newbie Q - Re: Copying databases

2005-04-29 Thread [EMAIL PROTECTED]
I am having to operating MySQL 4.0.18, I had heared that I could copy a db folder out of the mysql/data folder to the same folder on a different machine running its own local host server and that server would have a copy of the database. HOWEVER, o some occasions this seemed to work Ok, and on

RE: Newbie Q - Re: Copying databases

2005-04-29 Thread mathias fatene
] [mailto:[EMAIL PROTECTED] Sent: samedi 30 avril 2005 00:30 To: mysql@lists.mysql.com Subject: Newbie Q - Re: Copying databases I am having to operating MySQL 4.0.18, I had heared that I could copy a db folder out of the mysql/data folder to the same folder on a different machine running its own local

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