I want to do a complete server backup.
I already have my backup script copying all of the html/php files for the web app, and the mysql databases, placing them into a .tar.gz file.
How can I add the crontab files to that backup?
Whenever I save the crontab, it goes to /tmp folder.. and when I check that folder immediately afterwards, it is empty.
In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, that kind of thing. Should this database be backed up? Will backing up and attempting to restore it break things?
I've had a heck of a time Googling for "mysql backing up mysql database" as you can imagine.
I just reinstalled my system, I didn't do dump backup but I still have the physical folder of my previous mysql installations.
Is possible to use it to restore and update my current configuration?
Is it possible to restore a duplicity backup from a certain time in the past?
For example, if I'm making daily incremental backups, is there a way to restore a backup from three days ago?
It is a common situation, when administrator makes system for automatic backuping and forgets it. Only after a system fails administrator notices, that backup system has broken before or backups are unrestorable because of some fault and he has no current backup to restore from... So what are best practices to avoid such situations??