Re: Problem restoring database from a sql file created by mysqldump
At 18:01 +0100 7/30/03, Gilbert Wu wrote: Hi, I used the command similar to the following to dump out both the structure and contents of my database: mysqldump -F -u root --opt tradingdata >"c:tradingdatadump.sql" I got an error half way through restoring the database into another test database using the following command: mysql -u root -Dtradingata -htesthost < "c:tradingdatadump.sql" The error is: ERROR 1064 at line 5420: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '' at line 1. What does line 5420 of the dump file look like? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem restoring database from a sql file created by mysqldump
Hi, I used the command similar to the following to dump out both the structure and contents of my database: mysqldump -F -u root --opt tradingdata >"c:tradingdatadump.sql" I got an error half way through restoring the database into another test database using the following command: mysql -u root -Dtradingata -htesthost < "c:tradingdatadump.sql" The error is: ERROR 1064 at line 5420: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '' at line 1. It seems like mysqldump is having problems in dumping out the contents properly. I would be grateful if someone could shed some light on this. Perhaps things like what flag to use to delimit the contents correctly before the dump etc. Many Thanks. Regards, Gilbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]