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.
Re: Now is the time to automate mysqldump
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.