> I don't have any data blobs in my database - which makes incremental > backups easier - I use rsync for files and do a nightly mysql dump. > Except for the first of the month, the diff of that nights backup > compared to first of month is saved to flat file for rsync. Binary blobs > in the database would likely mean I have to change my backup protocol, > but if it really is advantageous, I'd do it.
This is just an aside but are you aware of the '--hex-blob' argument to mysqldump? It causes binary data to be dumped as a hexadecimal string: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_hex-blob It's space-greedy (every byte in your original data requires two bytes in the dump file) but it seems like it would be compatible with your mysqldump/diff approach. Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
