Restoring differential backup files

view story

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)