Bug #14159 mysqldump should quote names in USE statements
Submitted: 19 Oct 2005 22:57 Modified: 29 Mar 2006 1:59
Reporter: Alexander Kirillov Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.25/4.0.XX BK source OS:Linux (Linux)
Assigned to: Andrei Elkin CPU Architecture:Any

[19 Oct 2005 22:57] Alexander Kirillov 
Description:
database names appear unquoted in USE statements within dumps generated with mysqldump --quote-names.
if those names contain blanks this will cause problems later down the road.

How to repeat:
# mysqldump --quote-names --all-databases --result-file=DUMP.SQL
where some databases have blanks in their names.
# cat DUMP.SQL | grep '^USE'

Suggested fix:
# cat DUMP.SQL | sed 's|^USE \([^;]*\)|USE `\1`|g' >DUMP.SQL.FIXED
seems to be a workaround
[19 Oct 2005 23:34] MySQL Verification Team 
Thank you for the bug report.
This bug not affects 4.1.XX and 5.0.XX.
[29 Mar 2006 1:59] Brian Aker 
Please use a newer version of MySQL.