At 14:11 +0200 5/14/02, Ronald Landheer wrote:
>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.