Restoring db from mysqldump output problem...

[Jeff Snoxell]

Hello,

I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option.

When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB < JeffsDB.sql

I get:

ERROR 1065 at line 21: Query was empty

Now, line 21 of the SQL file contains:

/*!40000 ALTER TABLE Dealers DISABLE KEYS */;

If I remove all the lines like the one above then something seems to happen but the process terminates moaning about some problem in my SQL statement... it points to a huge (1Mb ish) single line of values which were created by mysqldump and which, hence, _should_ be ok shouldn't they.

My questions:

1. Why should I have to remove those comments from the SQL shouldn't it just work?

2. Any ideas as to why, even with the comments removed, my SQL is reported as erroneous? Is it something to do with the very long single line and the fact that my mysql server is remote?

Many thanks, again!,


Jeff


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php