1

Restoring diff files

view story
linux-howto

http://www.unix.com – I'm using a script (automysqlbackup) to dump mysql db's to .sql file followed by taking one full backup of the .sql file and the differential backups of the newer sql file every day using the tool diff. Now the backup destination folder contains files like, Quote: --- testdatabase.sql - first day - 1 MB --- testdatabase.diff1 - second day - 200 KB --- testdatabase.diff2 - third day - 140 KB I would like to how do i restore from these backups, say if I want to apply the diff1 to the full backup file testdatabase.sql. (HowTos)

robot1's picture
Submitted by robot1 on 09/05/2012

Stories similar to Restoring diff files

I'm using a script (automysqlbackup) to dump mysql db's to .sql file followed by taking one full backup of the .sql file and the differential backups of the newer sql file every day using the tool diff.

Now the backup destination folder contains files like,

Quote:

--- testdatabase.sql - first day - 1 MB --- testdatabase.diff1 - second day - 200 KB --- testda

I've tested a few of backup utilities and still haven't found one that would satisfy me.

Almost every one of them has two options: - full backup - not an option to use frequently - incremental backup - seems right, but there's one thing about it: Incremental backup builds on a base of a full backup, backing up only those files, that were created/changed.

Hi All,

Can differential backups be used to solve missing incremental backups?

Say you take daily incremental backups, then for one reason or another you lose the incremental backups for the next 3 days. Can you perform a differential backup to cover to gap somehow?

I'm trying to compare files on the root file system with a backup, and I'd like the comparison to work a bit like git or svn diff when a file has been added or removed - That is, display the full file diff. diff unfortunately just prints a No such file or directory message, which is not very useful.

I have a CentOS server running with backup made to an external HDD.

I run a full backup everyday at 4am and incremental backups every 2 hour.

ext4 backup 3 years 15 weeks ago

I am in the process of installing 11.2 (X86-64). By default the root partition was formatted as ext4. I am also thinking of possibly using raid 1 for some partitions (disks). While doing some research for this I discovered an item that stated the dump package (dump restore) does not support ext4 and worse may appear to dump but not be able to restore.

incremental or full backup ??? 41 weeks 4 days ago

Hi. Can someone tell me if the following script that i have made is a script for INCREMENTAL BACKUP or FULL BACKUP.

We are using Net Backup as a corporate solution. Incremental backups are taken daily during the week and then a weekly backup is done at the weekend (Saturday).

My colleague has restored a folder to how it stood at 14:00 on a Tuesday. The problem is that the restore is taking files from the weekend backup if they did not exist at that point in time of the restore.

What exactly does the default ibdata1 file store that does not exist in a mysqldump?

I've got a backup/rsync job that stores dump files of a MySQL 5.5 database on a remote server for rotating daily/weekly backups.

However, I am not currently backing up the ibdata1 file itself -- is this a nightmare waiting to happen or are dump files enough?

Thanks