mysqlhotcopy -q --allowold --keepold phpbb /var/backups
Invalid db.table name 'phpbb.phpbb`.`phpbb_auth_access' at
/usr/bin/mysqlhotcopy
line 859.
Usage: /usr/bin/mysqlhotcopy db_name[./table_regex/]
[new_db_name | directory]
Brilliant, it’s a bug:
http://bugs.mysql.com/bug.php?id=27303
"A quick and dirty fix is to strip the database prefix from the list of tables. This
happens
in function get_list_of_tables(). Adding the following line right behind line
835
will
strip the prefixing schema:
map
{ s/^.*?\.//o } <at> dbh_tables;"
So:
ci -l /usr/bin/mysqlhotcopy
vi /usr/bin/mysqlhotcopy
rcsdiff /usr/bin/mysqlhotcopy
===================================================================
RCS file: /usr/bin/mysqlhotcopy,v
retrieving revision 1.1
diff -r1.1 /usr/bin/mysqlhotcopy
839a840
> map { s/^.*?\.//o }
<at> dbh_tables; # http://bugs.mysql.com/bug.php?id=27303
==> This fix works, but is ugly. Anyway for now it have to be
manually added to any Gutsy Installations
Sean
---------- Forwarded message ----------
From: Cron Daemon
Date: 27 Nov 2007 00:10
Subject: Cron <root <at> freenacweb> mysqlhotcopy -q --allowold
--keepold phpbb /var/backups
Invalid db.table name 'phpbb.phpbb`.`phpbb_auth_access ' at
/usr/bin/mysqlhotcopy line 859.