Use option "-K or --no-disable-keys" with myqldump.
> Date: Mon, 15 Apr 2002 09:37:43 -0400 > To: [EMAIL PROTECTED] > From: Bill Marrs <[EMAIL PROTECTED]> > Subject: "gunk" in mysqldump output > > In some recent release of MySQL, lines like this: > > /*!40000 ALTER TABLE States DISABLE KEYS */; > > ...were added to the output of "mysqldump --opt". > > This causes my usually "load" statement: > > "mysql < dumpfile" > > ...to fail with "ERROR 1046 at line 11: No Database Selected". > > If I do "mydsql -f < dumpfile" it works (with errors), but I figure I'm > missing something. > > Why were these /*... lines added to dump output if they don't parse? > > Should I be using some alternate method for loading now? > > -bill --------------------------------------------------------------------- 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