Results 1 to 7 of 7

Thread: cannot open index file

  1. #1

    Default cannot open index file

    Hi All,
    when I run following command
    mysql-zrm --action parse-binlogs --source-directory=/usr/local/mysql/data, it is expected to obtain bin-log messages, however, "BackupSet1arse-binlogs:ERROR: cannot open index file /usr/local/mysql/data/index No such file or directory" is show out.
    Is there any one can help me?
    Thanks

    Mavis

  2. #2

    Default

    source-directory value should be a directory where incremental backups are stored.

    It has the format <destination-directory>/<backup set name>/<date stamp>

    /usr/local/mysql/data appears to be incorrect

    Paddy
    [URL=http://amanda.zmanda.com/]Amanda backup and recovery [/URL]
    [URL=http://www.zmanda.com/backup-mysql.html]MySQL backup and recovery[/URL]

  3. #3
    Join Date
    Jan 2012
    Posts
    1

    Default

    Hi paddy,

    It's interesting that you say that because according to [url]http://wiki.zmanda.com/index.php/How_do_I_recover_data_when_there_is_a_failure_or_d ata_loss%3F#Restoration_based_on_timestamp_-_Point_in_time_recovery[/url] that is exactly what you are supposed to do to parse the current bin logs in /var/lib/mysql

    Is there no current way to parse bin logs not part of a backup set? If not, what is the current solution to replay bin logs with mysql-zrm that are not part of a backup directory?

  4. #4

    Default

    mysql-zrm-parse-binlogs can only work on incremental backups. If you want to parse binary logs that are not part of backup directory, use mysql command - mysqlbinlog.
    [URL=http://amanda.zmanda.com/]Amanda backup and recovery [/URL]
    [URL=http://www.zmanda.com/backup-mysql.html]MySQL backup and recovery[/URL]

  5. #5

    Default

    Quote Originally Posted by paddy View Post
    source-directory value should be a directory where incremental backups are stored.

    It has the format <destination-directory>/<backup set name>/<date stamp>

    Paddy
    That is exactly correct. I changed to backup directory and boom it worked! Thanks.

  6. #6
    Join Date
    Jun 2013
    Location
    Lithuania
    Posts
    1

    Default

    Same problem, but this method not worked for me...

  7. #7
    Join Date
    May 2013
    Posts
    1

    Default

    its not working friend..

Posting Permissions

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