PDA

View Full Version : Help!!! A thread was removed by accident

vividbreeze
10-16-2009, 01:08 AM
Can I retrieve it back somehow some way after choosing DELETE physically ????
TheLastSuperman
10-16-2009, 01:12 AM
Ohh my hmm.. not sure about now maybe Database wise but there is a mod to prevent this... I hate posting w/o links if I track it down tonight I'll post back else search for it and good luck!

S-MAN
vividbreeze
10-16-2009, 01:14 AM
the url was http://www.truckmountforums.com/forums/daily-news-and-events/7019-jeff-lydon-greenglides-greenie-chem-dry-home-depot-harris-research-carpet-cleaning-glides-mb-mytee-26.htm with over 14,000+ views and its removed physically and i have not backed up the mysql database in almost 2 weeks............... argh any ideas? Could it still be in mysql database by ANY chance????
Lynne
10-16-2009, 01:28 AM
You are SOL. The only way to get back a physically deleted thread is to restore to a previous backup. (Unless you are a vbulletin and mysql wizard.)
vividbreeze
10-16-2009, 01:42 AM
what about sql-rollback?
Baldilocks
10-16-2009, 02:06 AM
That's why I unchecked "Can physically remove threads" from even my own permissions. LOL. Never want that to happen.
Lynne
10-16-2009, 02:22 AM
what about sql-rollback?
I've never used that but I believe you can only use that if you use it right after you made your mistake, not several hours later.
vividbreeze
10-16-2009, 02:23 AM
its only been 1 hour....
Lynne
10-16-2009, 02:24 AM
Still, it isn't *right* after. I think it's a function you use to undo what you just did. But, I'm not sql expert, so I really am not sure.
vividbreeze
10-16-2009, 02:25 AM
feel like taking on a task for some $? :)

--------------- Added 1255663695 at 1255663695 ---------------

oh ok
natecoupons
11-30-2009, 08:14 PM
That's why I unchecked "Can physically remove threads" from even my own permissions. LOL. Never want that to happen.

sorry to hijack...but where do i uncheck that??

--------------- Added 1259619509 at 1259619509 ---------------

sorry after some more searching i found it :)
final kaoss
11-30-2009, 08:21 PM
mysql> rollback;

or try
http://search.mysql.com/search?q=rollback