Red Hat Bugzilla – Bug 164134
mysqlhotcopy fails with cryptic error message
Last modified: 2013-07-02 23:06:08 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.7.10) Gecko/20050720 Fedora/1.0.6-1.1.fc4 Firefox/1.0.6
Description of problem:
mysqlhotcopy has started failing for me. I must have something wrong, but I can't work out why because the failure message is cryptic and doesn't tell me what's wrong.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. cd /
2. mysqlhotcopy --allowold -u njh -p xxxxx mysql mnt/backup
Actual Results: Copying indices for 0 files...
mysql -> mnt/backup/mysql failed: Error: cp -p '/var/lib/mysql/mysql/HKCLASSES.MYD' '/var/lib/mysql/mysql/HKCLASSES.MYI' '/var/lib/mysql/mysql/HKCLASSES.frm' '/var/lib/mysql/mysql/NABBC.MYD' '/var/lib/mysql/mysql/NABBC.MYI' '/var/lib/mysql/mysql/NABBC.frm' '/var/lib/mysql/mysql/columns_priv.MYD' '/var/lib/mysql/mysql/columns_priv.MYI' '/var/lib/mysql/mysql/columns_priv.frm' '/var/lib/mysql/mysql/db.MYD' '/var/lib/mysql/mysql/db.MYI' '/var/lib/mysql/mysql/db.frm' '/var/lib/mysql/mysql/func.MYD' '/var/lib/mysql/mysql/func.MYI' '/var/lib/mysql/mysql/func.frm' '/var/lib/mysql/mysql/host.MYD' '/var/lib/mysql/mysql/host.MYI' '/var/lib/mysql/mysql/host.frm' '/var/lib/mysql/mysql/tables_priv.MYD' '/var/lib/mysql/mysql/tables_priv.MYI' '/var/lib/mysql/mysql/tables_priv.frm' '/var/lib/mysql/mysql/user.MYD' '/var/lib/mysql/mysql/user.MYI' '/var/lib/mysql/mysql/user.frm' 'mnt/backup/mysql' failed (256) while copying files.
Expected Results: Should back up the database to /mnt/backup
Yes, the directory "/mnt/backup/mysql" does exist, and is writeable. Anyway running as root doesn't help.
Hmm, could it be a SELinux issue? Try "/usr/sbin/setenforce 0" and see if the behavior changes.
If so, update to the latest selinux-policy-targeted package and do /sbin/restorecon -R /usr/bin
to make sure the mysql programs are all properly security-labeled.
(This is a mass update of bugs which have been in the NEEDINFO state unmodified
for over a year and have not been confirmed for a still supported version of
Closing per lack of response to previous request for information.
This bug was originally filed against a much earlier version of Fedora
Core, and significant changes have taken place since the last version
for which this bug is confirmed.
Note that FC3 and FC4 are supported by Fedora Legacy for security
fixes only. Please install a still supported version and retest. If
it still occurs on FC5 or FC6, please reopen and assign to the correct
version. Otherwise, if this a security issue, please change the
product to Fedora Legacy. Thanks, and we are sorry that we did not
get to this bug earlier.