Working with MySQL:
My colleage did a mysqldump -u root <databasename> > file.txt and it dumped the database and all its content and then dropped the database.
Except he forgot the -R flag, which should dump the stored procedures too.
I hope backups have been running without any problems.
September 8th, 2006 1:45pm
It really shouldn't be that easy to delete a database.
My team does release notes telling our customers what happens to their systems with each scheduled update.
One time there was a massive shitstorm because the doc didn't mention a particular table dropping, and the customer was using it at the time - suddenly it just disappeared. Investigation turned up that it wasn't in the list of tables that would be dropped for the upload because it was never actually dropped - instead all access rights to it were revoked. Naturally it didn't occur to the developer to pass on that information...