At Wed, 4 Jan 2012 16:14:07 +0000, Chris Green wrote:
It does make me want to find a sensible way of backing up those mysql databases though. My automatic (cron) incremental backups save /home and /etc. I have made /var/www a symbolic link to a 'home' directory for www-data (the apache UID) at /home/www-data/www so all my web stuff gets backed up too.
Any comments/ideas anyone?
Prefer mysqldump over copying /var/lib/mysql/foo/*. Add suitable mysqldump calls to your cron job, sending output to somewhere under /home.
Best, Richard