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