31 May 2007
Drop database

The first time I read about MySQL*, I thought the drop database command was a dangerously easy way to delete a full database. Yesterday afternoon, I found out the hard way that it is a rather dangerous command, especially when your terminal window has a different database loaded than you thought it had… And for a change I regretted there was no Microsoft-style ‘are you sure you want to delete the whole database and be under severe stress for the rest of the evening?’-warning.

Luckily, there are things such as backups and server logs, the combination of which led to the harm being rather small after all and relatively easy to undo. But still, it took some hours before the stress got out of my body.

* MySQL is a widely used database system. It should, apparently, be pronounced my sequel rather than my s-q-l.

1 comment

Loading comments...
If you don't see anything appear within ten seconds or so, please use this direct link.
about
think small (thĭngk smôl) v. 1 lo-fi pop → song by New Zealand band → Tall Dwarfs. 2 pretentious internet → fanzine about music, 2002-2005, run by → Martijn from → Nijmegen, The Netherlands. 3 indiepop → song by Swedish band → The Budgies, based on a → review on the fanzine. 4 blog about music and other things, 2006-, run by M. from → Exmouth then → Exeter, Devon, UK.
record sale
Save hundreds of records from eternally collecting dust. Click here for the list.
meta
RSS
Contact
Powered by WordPress