SQL Truncate is a powerful tool

Thursday, December 11. 2008

SQL Truncate is a powerful tool

...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.

Posted by Brendon Kozlowski at 12:58 | Comments (3) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

That blows...no backups?

#1 Mike (Homepage) on 2008-12-12 11:14 (Reply)

Oh yeah, remember this?

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

#2 Mike (Homepage) on 2008-12-12 11:16 (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.

#3 Brendon Kozlowski (Homepage) on 2008-12-15 07:17 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Standard emoticons like :-) and ;-) are converted to images. 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. Enter the string from the spam-prevention image above: BBCode format allowed
	Remember Information? Subscribe to this entry

	March '10
Sun	Mon	Tue	Wed	Thu	Fri	Sat
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31