Ubuntu Tutorials

I added table optimization to the sqlbackup script. This now:

optimizes existing databases (similar to defrag)
dumps them thru bzip2 & stores in $dest by $date

dumps directly into a remote mysql-server

rsyncs database dump to remote machine for archiving.

If this article has been helpful, please consider linking to it.