Hello all, When testing some of our Perl/DBI code, we made a couple of tables with numeric names (e.g. test.1 test.2 etc), because the code we're making has to be able to handle them correctly. It does, w/o any problem, but mysqldump doesn't: I get a message "mysqldump: Got error: 1064: You have an error in your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK TABLES" while dumping "test.1". The syntax for mysqldump is: mysqldump --quick --lock-tables --add-drop-table --user=root test
mysqldump Ver 8.14 Distrib 3.23.41, for redhat-linux-gnu (i386) If you have any questions, don't hesitate to ask - I'm on the list and will be watching this thread. Thanx! Ronald --------------------------------------------------------------------- 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