PDA

View Full Version : mysqlhotcopy did not succeed



daseddy
July 4th, 2008, 05:37 AM
I try to backup my mysql server, but but every attempt failed.
System:
SunOS servername 5.10 Generic_137111-02 sun4v sparc SUNW,SPARC-Enterprise-T2000
MySQL-Version: 5.0.56sp1-enterprise-gpl



root @ servername [ /etc/mysql-zrm/dailyrun ]#mysql-zrm-scheduler --now --backup-set dailyrun
schedule:INFO: ZRM for MySQL Community Edition - version 2.0
Logging to /var/log/mysql-zrm/mysql-zrm-scheduler.log
backup:INFO: ZRM for MySQL Community Edition - version 2.0
dailyrun:backup:INFO: START OF BACKUP
dailyrun:backup:INFO: PHASE START: Initialization
dailyrun:backup:INFO: backup-set=dailyrun
dailyrun:backup:INFO: backup-date=20080704150717
dailyrun:backup:INFO: mysql-server-os=Linux/Unix
dailyrun:backup:INFO: host=localhost
dailyrun:backup:INFO: backup-date-epoch=1215176837
dailyrun:backup:INFO: mysql-zrm-version=ZRM for MySQL Community Edition - version 2.0
dailyrun:backup:INFO: mysql-version=5.0.56sp1-enterprise-gpl-log
dailyrun:backup:INFO: backup-directory=/usr/local/mysql/backup/zrm/dailyrun/20080704150717
dailyrun:backup:INFO: comment=Backup Mysql1 Instanz 1
dailyrun:backup:INFO: backup-level=0
dailyrun:backup:INFO: backup-mode=raw
dailyrun:backup:INFO: PHASE END: Initialization
dailyrun:backup:INFO: PHASE START: Running pre backup plugin
dailyrun:backup:INFO: PHASE END: Running pre backup plugin
dailyrun:backup:INFO: PHASE START: Stopping slave
dailyrun:backup:INFO: PHASE END: Stopping slave
dailyrun:backup:INFO: PHASE START: Flushing logs
dailyrun:backup:INFO: PHASE END: Flushing logs
dailyrun:backup:INFO: PHASE START: Copying replication data
dailyrun:backup:INFO: replication=master.info relay-log.info
dailyrun:backup:INFO: PHASE END: Copying replication data
dailyrun:backup:INFO: PHASE START: Creating snapshot based backup
dailyrun:backup:INFO: File Position Binlog_Do_DB Binlog_Ignore_DB
bin-log.000047 98
dailyrun:backup:ERROR: Unable to copy from links
dailyrun:backup:INFO: PHASE END: Creating snapshot based backup
dailyrun:backup:INFO: PHASE START: Find table type
dailyrun:backup:WARNING: Database bio34 is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h0053fcg is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h04512hr is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h0451328 is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h0451c1i is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h0451c1p is empty and hence will not be backedup
dailyrun:backup:WARNING: Database h364826c is empty and hence will not be backedup
dailyrun:backup:WARNING: Database nagios is empty and hence will not be backedup
dailyrun:backup:WARNING: Database web0108 is empty and hence will not be backedup
dailyrun:backup:WARNING: Database webadm is empty and hence will not be backedup
dailyrun:backup:INFO: PHASE END: Find table type
dailyrun:backup:INFO: PHASE START: Creating raw backup
dailyrun:backup:ERROR: Output of command: 'mysqlhotcopy' is {
sh: /usr/local/mysql/server/mysql-enterprise-gpl-5.0.56sp1-solaris10-sparc-64bit/bin/mysqlhotcopy: not found
}
dailyrun:backup:ERROR: mysqlhotcopy did not succeed. Command used is "/usr/local/mysql/server/mysql-enterprise-gpl-5.0.56sp1-solaris10-sparc-64bit/bin"/mysqlhotcopy --user="root" --password="*****" --socket="/tmp/mysqld1.sock" --quiet IQB_IB_TEST ai_sommeruni bio13 bio17 bio20 blogDB employee gleitzeit h0051clg h00522p9 h044418j h04510gr h04510gv h04511kb h04511kb_2 h04511kb_3 h04511kc h04511ke h04512aa h04512ht h04512hv h04512hw h045132b h045132c h045132e h0451b01 h0451b02 h0451b06 h0451b0d h0451b0k h0451b0o h0451b0p h0451b0s h0451bcn h0451bcq h0451bct h0451bcx h0451bcz h0451c1k h0451cna h0451cnc h0451cnf h0451cng h0451cni h0451d5s h0451d5y h0451h2x h0451h2y h0451i1j h0451i1l h0451kl4 h0451kl5 h0451l40 h0451l43 h0451l45 h0451l6v h0584azo kalender movado musiklandschaft mysql pma_test psy roundcubemail roundcubetest test walter web0003 web0016 web0020 web0024 web0027 web0029 web0033 web0038 web0042 web0044 web0045 web0048 web0056 web0061 web0071 web0072 web0081 web0096 web0102 web0103 web0105 web0115 web0122 "/usr/local/mysql/backup/zrm/dailyrun/20080704150717" > /tmp/HiZDb18qNU 2>&1 Return value is 256
dailyrun:backup:INFO: PHASE START: Cleanup
dailyrun:backup:INFO: backup-status=Backup failed
dailyrun:backup:INFO: Backup failed
dailyrun:backup:INFO: PHASE END: Cleanup
dailyrun:backup:INFO: END OF BACKUP
ERROR: /usr/bin/mysql-zrm did not finish successfully


mysqlhotcopy exists and can be executed.



root @ servername [ /etc/mysql-zrm/dailyrun ]#ls -al /usr/local/mysql/server/mysql-enterprise-gpl-5.0.56sp1-solaris10-sparc-64bit/bin/mysqlhotcopy
-rwxr-xr-x 1 mysql mysql 32562 Mar 19 16:08 /usr/local/mysql/server/mysql-enterprise-gpl-5.0.56sp1-solaris10-sparc-64bit/bin/mysqlhotcopy*


Thanks a lot.
Matthias

kkg
July 31st, 2008, 11:12 PM
Please run the backup with --verbose and post the logs.

--kkg