I have linux
centos 6.4 server with
I have the cron job for making hourly mysql database backups like this
Its in python
os.popen("mysqldump -u %s --password=%s -h %s -e --opt --skip-lock-tables --skip-extended-insert -c %s | gzip -c > %s.gz" % (username, password, hostname, database, filename))
The problem is very little data gets chnaged but every time i have to backup all databases 24 times , which takes too much space.
What is best alternative for that
Is there any way to have incremental backups so that i take 1 full backup of database evry week and then only incremental backups.
I want to have separate files for separate databases so that if i need to restore single database then i can do that as well