MySQL Bugs: #10642: DROP TABLE fails if Table name contains a space

Bug #10642	DROP TABLE fails if Table name contains a space
Submitted:	15 May 2005 0:26	Modified:	20 May 2005 9:15
Reporter:	Tom Gubler	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.19 & 1.0.20	OS:	Windows (Windows XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
The Backup File created by MySQL Administrator will analyse as being OK but when the Restore is commenced the eg DROP TABLE IF EXISTS 'Master Stock`; line fails if there is a space in the Table name.

How to repeat:
Create a Backup File with MySQL Administrator on a database that has a table in it with a space in the Table name and ensure the Add Drop Staements setting is on then when the restore is commenced the
 eg DROP TABLE IF EXISTS 'Master Stock`;

 line fails.

Thank you for the bug report.

Warning: Do not know how to handle this statement at line 27:
DROP TABLE IF EXISTS `master stock`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

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