MySQL Bugs: #7962: Mishandling of multiple word table names in Backup/Restore

Bug #7962	Mishandling of multiple word table names in Backup/Restore
Submitted:	17 Jan 2005 17:10	Modified:	2 May 2005 16:15
Reporter:	Robert Hammond	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.19	OS:	Windows (Windows 2000)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
If a table name includes a space, the Restore function does not seem to know how to handle the name.  This is seen in two places.  
1. When viewing the Restore Content tab, the table name will be cropped the from one character to the left of the space though the end of the word. I.e. Table name: "test me" Displayed as "tes"
2. When Start Restore is pressed, the process returns an error message of:
"Warning: Do not know how to handle this statement at line 13:
DROP TABLE IF EXISTS `test me`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized."

How to repeat:
Run:
CREATE TABLE `test me` (
 `ID` int(10) unsigned NOT NULL auto_increment,
 `TestField` varchar(45) NOT NULL default '',
 PRIMARY KEY  (`ID`)
 TYPE=InnoDB COMMENT='This is to reproduce the MySql listed bug.';

INSERT INTO `test me` ( TestField ) VALUES ( 'TestLine1' ), ( 'TestLine2');

Create a backup that includes the test db and 'test me' table. Options to use: Lock all tables,  Add DROP TABLE Statements, Complete INSERTs.  All others set to default.

Open the saved backup file in the Restore tab.  Analyze to verify incorrect name.  Attempt Start Restore to verify Warning.

The bug is still present in Administrator v1.0.20

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html