Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    'incremental' backup of mysqld files

    Is there a way to make a backup of only the changes of a .MYD / .MYI file to e.g. a ftp server?

    I used to rsync all mysql files to an other server which is not possible with the ftp storage I just received.

    yes, I know you can run a bin-log (which I am doing) but it would take about 12h in case of a crash to play everything back for a 1-day binlog and even longer for a weekly snapshot.

    I imagine something like this:

    - mysql slave server contains:
    - directory with the most current data
    - directory with data which is exactly 24h old

    => I'd like to make some kind of 'diff' between the files in these directories, similar to how rsync does it, compress it and transfer it to the ftp server. Once a week I'll do a full backup (80GB data)

  2. #2
    Join Date
    May 2003
    Bayreuth, Bavaria, Germany
    there are several "binary diffs" available ...
    e.g. this one: (which may consume too much memory in your case)
    or (the IMHO best one)


Posting Permissions

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