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