SQL Truncate is a powerful tool

Thursday, December 11. 2008

...and I just truncated a database rather than a table completely on accident (yay for GUIs and quick-clicking). All of the data for my Reference Stats application has been lost. I'm rather upset with myself at the moment; I had thought I propogated it to the live database.

Geschrieben von Brendon Kozlowski
Comments (3) Trackbacks (0)
Sie können einen Kommentar hinterlassen, oder ein Trackback von Ihrem eigenen Blog senden.

Trackbacks


Trackback specific URI for this entry
    No Trackbacks

Comments


    #1 Mike on 12/12/08 at 11:14 AM [Reply]
    That blows...no backups? :(
    #2 Mike on 12/12/08 at 11:16 AM [Reply]
    Oh yeah, remember this?

    http://ex-libris.ca/?p=258

    ;)
    #3 Brendon Kozlowski on 12/15/08 at 07:17 AM [Reply]
    Ha! Wow, I sounded much more MySQL savvy then. Unfortunately, the MySQL backup log was from my previous install of my machine, and when I was running v4, not v5. I think I should re-enable that. I thought I also had a backup on my dev machine, but was mistaken. Quite ironic that I said the GUI would alleviate such errors. ;) I could use commit/rollback but find it a hassle for a dev machine.

Add Comment

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

BBCode format allowed