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]
