Results 1 to 3 of 3

Thread: Incremental can't find bin-files

  1. #1
    Join Date
    Apr 2011
    Posts
    3

    Default Incremental can't find bin-files

    We got everything working fine doing full raw backups over SSH but when it comes to Incremental we get the following error:

    Code:
    Test:backup:INFO: PHASE START: Creating incremental backup
    src = /var/lib/mysql/mysql-bin.000028
    k = /var/lib/mysql-zrm/Test/20110428182722/mysql-bin.000028
    tar: mysql-bin.000028: Cannot stat: No such file or directory
    tar: Error exit delayed from previous errors
    Test:backup:ERROR: Could not copy bin log file /var/lib/mysql-zrm/Test/20110428182722/mysql-bin.000028
    Test:backup:INFO: incremental=mysql-bin.[0-9]*
    Test:backup:INFO: PHASE END: Creating incremental backup
    There is no 'mysql-bin.*' in any of the two directories meantioned on any server. However I do find these files on the DB-server in '/var/log/mysql'.

    Can and should I change where ZRM looks for these binary logs or have I configured something else wrong here?

    Thanks for a great software and community!

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Set mysql-binlog-path to /var/log/mysql in the mysql-zrm.conf

  3. #3
    Join Date
    Apr 2011
    Posts
    3

    Default

    Thanks Paddy, such an easy fix and all working now.

    Did look through the conf-file earlier but missed this option somehow...

Posting Permissions

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