Saved

[prog]

I wish there was a nearby shrine to MySQL I could go visit. I'd like to go there and burn some incense or something.

In the middle of some pretty hairy DB work in order to make the revenue reports work, and I swear to you, all my guesses as to syntax for bizarro table relations that looked like they might work actually did work.

If this were Oracle, this would have taken me a week to figure out.

Comments

Re: Now is the time to automate mysqldump

[daerr.livejournal.com]

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.