MySQL Bugs: #27764: Restore operation fails with tablenames containing numeric character(s)

Bug #27764	Restore operation fails with tablenames containing numeric character(s)
Submitted:	11 Apr 2007 18:41	Modified:	11 Apr 2007 19:44
Reporter:	Hans-Peter Scheidegger	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.10	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	numeric character, restore, tablename

Description:
The restore procedure fails under the following conditions:

A table with a tablename containing numeric characters eg `123` was been backuped with MySQL Administrator into a bak.sql file.

The bak.sql file has correct syntax

When loading the backup file into the restore section of MySQL Administrator, the table with numeric characters will not be shown in the 'analyse content' dialog and the restore procedure will crash.

We have:
MySQL Server Version: 4.1.21-community-nt
and we have 'lower_case_table_names=2' in the mysql.ini file

How to repeat:
/* create the following table: */

CREATE TABLE `123` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `Description` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/* add some data or not */
/* do a backup.sql file with MySQL Administrator */
/* load the backup.sql file into the restore open file dialog */
/* analyse the file content */
/* do the restore procedure */

the dump 'bak.sql'

Attachment: bak.sql (text/plain), 1.79 KiB.

our 'my.ini' file

Attachment: my.ini (application/octet-stream, text), 9.83 KiB.

Thank you for the bug report. Duplicate of bug:
http://bugs.mysql.com/bug.php?id=26645