Results 1 to 2 of 2

Thread: mysqlhotcopy did not succeed

  1. #1

    Default mysqlhotcopy did not succeed

    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

    Code:
    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.

    Code:
    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
    Last edited by daseddy; July 4th, 2008 at 05:49 AM.

  2. #2
    Join Date
    Oct 2006
    Posts
    199

    Default

    Please run the backup with --verbose and post the logs.

    --kkg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •