Bug #14610 mysqlhotcopy tries to copy virtual information_scheme table
Submitted: 3 Nov 2005 16:11 Modified: 2 Dec 2005 20:44
Reporter: Elan Ruusamäe (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.16-BK, 5.0.15 OS:Linux (Linux)
Assigned to: Jim Winstead CPU Architecture:Any

[3 Nov 2005 16:11] Elan Ruusamäe
Description:
mysqlhotcopy  tries to copy 'information_schema' database

this is because mysqlhotcopy does 'show databases' which includes 'information_schema' in output.

How to repeat:
$ sudo mysqlhotcopy --regexp=. /tmp/
Cannot open dir '/var/lib/mysql/mysqldb/db/information_schema': No such file or directory at /usr/bin/mysqlhotcopy line 289.

Suggested fix:
skip copying of information_schema "database" for mysql versions >= 5.0.x
[4 Nov 2005 12:45] Valeriy Kravchuk
Thank you for a bug report. Verified just as described on today's 5.0.16-BK build (ChangeSet@1.1957.1.18, 2005-11-03 20:29:21+02:00, jani@ua141d10.elisa.omakaista.fi) on Linux Fedora Core 1:

[openxs@Fedora 5.0]$ mysqlhotcopy --regexp=. /tmp
Cannot open dir '/home/openxs/dbs/5.0/var/information_schema': No such file or directory at /usr/bin/mysqlhotcopy line 289.
[openxs@Fedora 5.0]$ mysqlhotcopy -?
Unknown option: ?
Invalid option
/usr/bin/mysqlhotcopy Ver 1.22
...
[11 Nov 2005 1:02] Bugs System
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/internals/32167
[30 Nov 2005 21:05] Jim Winstead
Fixed in 5.0.17.
[2 Dec 2005 20:44] Paul Dubois
Noted in 5.0.17 changelog.