Bug #35402 mysqlhotcopy fails to copy database - Can't find fild: './db_name/table_name.frm

• Submitted: 18 Mar 2008 15:19
• Modified: 18 Mar 2008 23:17
• Reporter: Loki Tek
• Status: Can't repeat
• Category: MySQL Websites: bugs.mysql.com
• Severity: S2 (Serious)
• OS: Linux (2.6.23.1-42.fc8)
• CPU Architecture: Any
• Tags: can't find file, error, mysqlhotcopy

[18 Mar 2008 15:19] Loki Tek

Description:
Seems I keep getting the same error, even if I add the split of MySQL tables through regex.

DBD::mysql::db do failed: Can't find file: './db_name/table_name.frm' (errno: 13) at /usr/bin/mysqlhotcopy line 467.

ls -la ./db_name/table_name.frm
-rw-r----- 1 root root 8888 2008-03-14 17:09 ./db_name/table_name.frm

How to repeat:
mysqlhotcopy -u root db_name /root/backup_mysql/ --allowold --regexp='^[a-m].+'.'.+'

or 

mysqlhotcopy -u root db_name /root/backup_mysql/ --allowold

Suggested fix:
allow the 
dbh->do to actually 'find' the tables/files in question?

[18 Mar 2008 16:56] MySQL Verification Team

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Notice error 13 means: 

[miguel@mira dbs]$ 5.1/bin/perror 13
OS error code  13:  Permission denied

[18 Mar 2008 23:12] Loki Tek

Miguel I'm not sure what's missing - Could you tell me what you're looking for specifically?
The following is done, while mysql is running:
cd /var/lib/mysql
mysqlhotcopy -u root db_name /root/backup/

The above command should copy the sql files to the folder /root/backup/ - instead it fails to do so, while outputting the error specified above.

[18 Mar 2008 23:17] Loki Tek

How do i change the status? The only options available to me are can't repeat and close?