PDA

View Full Version : error message



lovewadhwa
April 29th, 2007, 10:22 PM
hi
i m taking backup of single table of a database in raw mode..but getting the following error

No tables to hot-copy at /usr/local/mysql/bin/mysqlhotcopy line 393.
mysqlhotcopy on host 192.168.2.14 failed at /usr/share/mysql-zrm/plugins/ssh-copy.pl line 202

Kindly help regardin the same.

kkg
May 1st, 2007, 08:23 AM
hi
i m taking backup of single table of a database in raw mode..but getting the following error

No tables to hot-copy at /usr/local/mysql/bin/mysqlhotcopy line 393.
mysqlhotcopy on host 192.168.2.14 failed at /usr/share/mysql-zrm/plugins/ssh-copy.pl line 202

Kindly help regardin the same.

Hi,

given the limited info, you probably have an empty database. If you can post the detailed logs, that will be good. also please ensure that zrm is running as root.

--kkg

lovewadhwa
May 1st, 2007, 09:32 PM
hi
this is the output i get on screen when i m taking the backup of a particular table of a particular database.

Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
INFO: ZRM for MySQL Community Edition - version 1.1.5
INFO: Mail address: abcd@abcd.com is ok
INFO: Input Parameters Used {
INFO: verbose=1
INFO: mysql-binpath=/usr/local/mysql/bin
INFO: destination=/opt/mysqlzrm
INFO: password=******
INFO: backup-mode=raw
INFO: tables=RESUME1
INFO: compress-plugin=/usr/bin/gzip
INFO: user=backupuser
INFO: copy-plugin=/usr/share/mysql-zrm/plugins/ssh-copy.pl
INFO: quiet=0
INFO: backup-level=0
INFO: mailto=abcd@abcd.com
INFO: html-reports=backup-status-info, backup-performance-info
INFO: remote-mysql-binpath=/usr/local/mysql/bin
INFO: ssh-user=abcd
INFO: host=192.168.2.11
INFO: socket=/tmp/mysql.sock
INFO: database=test
INFO: html-report-directory=/opt/mysqlzrm/reports/
INFO: compress=/usr/bin/gzip
INFO: }
INFO: ZRM Temporary configuration file = /etc/mysql-zrm/remote/tmpU9MLH.conf
INFO: Getting mysql variables
INFO: "/usr/local/mysql/bin"/mysqladmin --user="backupuser" --password="*****" --host="192.168.2.11" --socket="/tmp/mysql.sock" variables
INFO: datadir is /usr/local/mysql/data/
INFO: mysql_version is 4.0.24-standard-log
INFO: log_bin=ON
INFO: InnoDB data file are /usr/local/mysql/data/ibdata1
INFO: InnoDB log dir is /usr/local/mysql/data/.
INFO: backup set being used is remote
INFO: backup-set=remote
INFO: backup-date=20070502105005
INFO: host=192.168.2.11
INFO: backup-date-epoch=1178083205
INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 1.1.5
INFO: mysql-version=4.0.24-standard-log
INFO: backup-directory=/opt/mysqlzrm/remote/20070502105005
INFO: Executing pre-backup-plugin
INFO: Flushing the logs
INFO: flush-logs
INFO: Getting master logname using command "/usr/local/mysql/bin"/mysql --user="backupuser" --password="*****" --host="192.168.2.11" --socket="/tmp/mysql.sock" -e "show master status"
INFO: backup-level=0
INFO: Command used for getting engine type "/usr/local/mysql/bin"/mysql --user="backupuser" --password="*****" --host="192.168.2.11" --socket="/tmp/mysql.sock" -e "show table status from \`test\` like 'RESUME1'"
INFO: For database test
INFO: and for table RESUME1
INFO: engine
INFO: MyISAM
INFO: Command used for raw backup is /usr/share/mysql-zrm/plugins/ssh-copy.pl --mysqlhotcopy=/usr/local/mysql/bin --user="backupuser" --password="*****" --host="192.168.2.11" --socket="/tmp/mysql.sock" --quiet test./^RESUME1$/ "/opt/mysqlzrm/remote/20070502105005" > /tmp/JCEc6uCj7e 2>&1
ERROR: Output of command: 'mysqlhotcopy' is {
No tables to hot-copy at /usr/local/mysql/bin/mysqlhotcopy line 393.
mysqlhotcopy on host 192.168.2.11 failed at /usr/share/mysql-zrm/plugins/ssh-copy.pl line 202.
}
ERROR: mysqlhotcopy command did not succeed.
Command used is /usr/share/mysql-zrm/plugins/ssh-copy.pl --mysqlhotcopy=/usr/local/mysql/bin --user="backupuser" --password="*****" --host="192.168.2.11" --socket="/tmp/mysql.sock" --quiet test./^RESUME1$/ "/opt/mysqlzrm/remote/20070502105005" > /tmp/JCEc6uCj7e 2>&1
Return value is 2816
INFO: backup-status=Backup failed
INFO: Backup failed
INFO: mailing file /tmp/59eLUFq7qo
INFO: mail command is cat "/tmp/59eLUFq7qo"|mail -s "Errors while running MySQL ZRM" abcd@abcd.com
ERROR: /usr/bin/mysql-zrm did not finish successfully

lovewadhwa
May 1st, 2007, 09:34 PM
in addition to the previous posted the zrm has been run with root privileges.

lovewadhwa
May 4th, 2007, 09:15 PM
hi
anyone out there to help me

kkg
May 6th, 2007, 09:27 PM
hi
anyone out there to help me


Please see what user mysql is running as on the remote machine. If you want you can try running zrm with ssh-user set as root.

--kkg

lovewadhwa
May 7th, 2007, 03:13 AM
mysql is being run with mysql user and zrm is bein run as root with ssh user as root.