List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 14 2002 2:03pm
Subject:Re: Error in mysqldump when using numeric table names
View as plain text  
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

Thread
--- InnoDB for Winmaxim14 May
  • Re: --- InnoDB for WinLuciano Barcaro14 May
    • Error in mysqldump when using numeric table namesRonald Landheer14 May
      • Re: Error in mysqldump when using numeric table namesPaul DuBois14 May
      • Re: Error in mysqldump when using numeric table namesEgor Egorov14 May
    • Newbie: How do I copy over a new database?Doug Coning18 May
      • Re: Newbie: How do I copy over a new database?MikeParton18 May
      • Re: Newbie: How do I copy over a new database?Victoria Reznichenko18 May
  • Reset Master ignores max_binlog_size variableAndre Stahl15 May