Speaking as someone who just had a server failure and is *still* trying to recover from it. Backup often and AUTOMATE it, and for the love of all that's holy... do a test restore from your backups on a semi regular basis!
I think I might have been happier if my box had a "catastrophic" failure, but what happened was more insidious. The memory went south, but not so bad that it would crashed the box. It introduced problems into my database and potentially into the process of trying to extract the data from the box. Since the memory wasn't bad enough to cause the box to fail I didn't notice a problem for a while. So every time I did something that saved information from main memory back to disk I was potentially corrupting my data. As a result I was wondering what dbmail users think of this potential enhancement: Add a column in the database for the physical message blocks that is the MD5 or SHA hash of the block at insert. This could be used by the dbmail utility to do a data validation and to catch problems in the db that might be caused by either memory or disk errors. -Brian On 7/4/06, DK <[EMAIL PROTECTED]> wrote:
On 7/4/06, Danil V. Gerun <[EMAIL PROTECTED]> wrote: > > > that is like 'mirroring' right? errmm..maybe i'll try it someday. > > right now can anybody share with me on differential/incremental backup? > What database do you use? > If MySQL, then check out the binary logs feature somewhere in manual for MySQL. > You can define a single database to keep binary logs for, or the whole server. Or exclude particular database(s). Well, I think I shouldn't retell the docs here, they are rather clear. > > The backup strategy is described here, for example: > http://downloads.mysql.com/docs/refman-4.1-en.chm > In Database Administration - Backup and Recovery > > The idea is simple (like newsyslog) - you set up binary logging, schedually do FLUSH LOGS (it rotates the binary log) and backup the fresh binary log. Every 7 times you can make a full backup and delete the logs. > > > > That's the problem I came accross some says ago, when camcontrol in FreeBSD started to show growing amount of defects on hard drive ;-) > > > > > > -- > Best regards, > Danil V. Gerun. > Check out http://www.nongnu.org/rdiff-backup/ -- Demi _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- /* insert witty comment here */
