At 14:11 +0200 5/14/02, Ronald Landheer wrote: >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
You also need the --quote-names option to tell mysqldump to quote the table names as `1`, `2`, etc. > >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