Amahi Forums

Since I lost so much (data, time, energy) in my harddrive failure (Ontrack sent it to their clean room so that shows it is bad), I am FINALLY developing an RSYNC-based backup scheme. I have a USB attached drive, so rsync run via cron is an easy solution. Provided you know what to back up! So far in my /etc/crontab I have:
I may add backing up /root to this, or in a onetime thing.

I learned how to get the local SID for Samba by:
but this is a onetime backup item that I would then push into a new server with
But there is the mysql database to back up as well. Where is that located?

And is there anything else I should consider backing up?

Why not just use the AutoMySQLBackup script to capture everything. It grabs all app dbs and the production db as well.

See http://wiki.amahi.org/index.php/Database_Backup. Then you can selectively restore the dbs needed.

This will be more sophisticated than I have implemented, and I will look into it, though I will still need to rsync the dbbackup directory. Here is what I figured out and put in place today (in /etc/crontab):
I figured out I needed to add the --stats option to the rsync to insure I get report emails. If the rysnc has nothing to report (eg errors), it does not generate an email to root. And -h just makes the numbers in --stats readable.

Why not just use the AutoMySQLBackup script to capture everything. It grabs all app dbs and the production db as well.

See http://wiki.amahi.org/index.php/Database_Backup. Then you can selectively restore the dbs needed.

The wget in the instructions did not work for me, I got a 404. I had to go directly to sourceforge and download the script via their standard web interface