MySQL Bugs: #26645: Can't restore backup files when the table begins with number not a char.

Bug #26645	Can't restore backup files when the table begins with number not a char.
Submitted:	26 Feb 2007 19:53	Modified:	30 Apr 2007 8:44
Reporter:	Wataru WAU	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.9	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
MySql Administrator 1.2.9 doesn't restore backup files that contain tables that begins with numbers like "1500850_03", only if I change it to "x1500850_03". In older versions I didn't have problems.

The warning message is:

Warning: Do not know how to handle this statement at line 28:
CREATE TABLE `1500850_03` (
  `FAM` tinyint(1) unsigned NOT NULL default '0',
  `SUB` tinyint(1) unsigned NOT NULL default '0',
  `CODIGO` int(10) unsigned NOT NULL default '0',
  `NIVEL` tinyint(2) unsigned NOT NULL default '0',
  `QTDE` float NOT NULL default '0',
  `POSICAO` text,
  PRIMARY KEY  (`FAM`,`SUB`,`CODIGO`,`NIVEL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

How to repeat:
Just create a table with name like "1234" and put some columns in it, then try to create a backup file and try to restore it.

It'll not restore...

If you change the table name to "x1234" and repeat the procedure you'll get the table restored.

Suggested fix:
Restore procedure corrected to accept tables beginning whith numbers...

Changed category to more appropriate one

Thank you for bug report.

Bug: http://bugs.mysql.com/bug.php?id=27764 was marked as duplicate
of this one.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html