MySQL Bugs: #44278: mysqlhotcopy unable to backup schema with a hyphen in its name

Bug #44278	mysqlhotcopy unable to backup schema with a hyphen in its name
Submitted:	15 Apr 5:26	Modified:	4 Aug 21:00
Reporter:	technical services division TSD
Status:	Patch pending
Category:	Client	Severity:	S2 (Serious)
Version:	1.23, 5.1, 6.0 bzr	OS:	Linux (RHEL4)
Assigned to:	Jim Winstead	Target Version:	5.1+
Triage:	Triaged: D3 (Medium)

Description:
mysqlhotcopy included in distribution 5.1.32 (and possibly previous) fails to backup
MyISAM schemas which names include '-'. These schemas are stored in directories which are
encoded to be file system neutral, thus those names differ. 

Executing mysqlhotcopy for such schemas results in following message:

Cannot open dir '/data/mysql/a-b-c': No such file or directory at /usr/bin/mysqlhotcopy
line 289.

This breaks current backup process 100% and requires new regime to be devised.

How to repeat:
Create schema: a-b-c

Execute: mysqlhotcopy -u backup -p xxxxx a-b-c /var/tmp

Thank you for the report.

Verified as described. Bug exists since version 5.1

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/80079

3055 Jim Winstead	2009-08-04
      mysqlhotcopy did not handle the encoding of schema names in the filesystem, so
      schemas with most non-alphanumeric characters in their name could not be
      backed up. (Bug #44278).