ext_214957 ([identity profile] daerr.livejournal.com) wrote in [personal profile] prog 2006-09-18 10:30 pm (UTC)

Re: Now is the time to automate mysqldump

We actually do a mysqldump every hour. Can't just backup the binary versions of the database without shutting it down, and who wants that? :)

My trick, which I haven't done with Volity yet, is to keep snapshots of the last 15 days of important databases, stored using MyISAM compressed tables. Doesn't take up too much space and gives live access to older data.

Post a comment in response:

This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting