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]
