Keith Devens .com - Weblog: Entry 1707

Monday, March 25, 2002

Entry 1707

You know, SQL is really dangerous. You forget a where clause - once - and you can wipe out an entire database.

Permalink | 4 Comments | id 1707

18:07 (utc-5)

Comments

Adam Vandenberg wrote:

mysqldump is Your Friend (TM).

So is having a couple of scripts to blow away and recreate a dev mirror of your production schema from:
1) Known test data
or
2) A copy of the current production DB

∴ Adam Vandenberg | 25-Mar-2002 6:33pm est | #140

Ha! A dev copy of the database... and an automated backup! Wuss

Adam Vandenberg wrote:

Well...
I only put in that kind of effort for my personal projects. I'd have to lose entries or whatever due to boneheadedness.
As far as work projects go, well, let's just say I charge an arm and a leg for DB script work that ventures into the realm of test tools.

∴ Adam Vandenberg | 26-Mar-2002 1:34am est | #143

Nice.

Feel free to post a comment below. Please see my comment policy.

Formatting Rules (No HTML):

**bold**, *italic*, _underlined_, --strikeout--
"text"="url" creates a link, and URLs are auto-highlighted
Blockquote: Like e-mail, begin paragraph with > (greater-than sign)
Lists: begin paragraph with *,-, or + (unordered), or # (ordered)
Code block: ?!code:language=perl|php|sql|javascript|etc.{\n}...{\n}?!/code

RSS feed RSS feed for Keith's Weblog
Atom feed Atom feed for Keith's Weblog
Weblog archive
Recent comments
on 5 posts