Small hint to optimize backups Use uncompressed backup, Luke.. It is amazing fast! Then, use 7z or RAR in SSH for fast compress of huge database, if necessary.
I use it for backup and restore my 12 GB database, with nice speed, without any errors. It's "must-have" mysql tool of russian admins. http://sypex.net/en/