Question HELP: How to retrive deleted Thread ?

It seems one thread got deleted from my site. I do not know how?

What is the correct way to retrive this deleted thread? I have back up of my site taken one month back. Now over 1 month there are several new threads are come up. What is the way to get this thread to PHPMYADMIN.

I really need this thread back, as it was most popular thread on our site. I dont know how it got deleted.

Hello,

If a thread has been deleted in k1.5, you can't retrieve it . If, you know the id of thread you could found it with phpmyamin, but if this thread has right been deleted, you will find nothing.

I think the better solution, is to use a backup if you have one.

If you have backup from the tables, you could find the deleted thread from there and move it back to real database. While it can be done, it's not easy task and needs deep understanding on sql language.

Matias wrote:

If you have backup from the tables, you could find the deleted thread from there and move it back to real database. While it can be done, it's not easy task and needs deep understanding on sql language.

Thank you xillibit and Matias for replying.

I have mysql backup. I am not able to figure out the exact sql query to execute this. The deleted thread was very important thread for me.

Can you suggest/direct my sql query to get back this thread online?

Sorry for delay, I've been away from the forum trying to finish K1.6..

As I said, there's no simple SQL query to get the data back to the main table. It's doable, but needs some understanding on SQL and some data mining. Did you already locate the topic?

Once you find one message in it, you will know the thread (field in jos_fb_messages). Once you know the thread, you can select all messages in it. And when you have that, you do INSERT INTO the live database with data from SELECT * WHERE thread=xxx.

PS. please backup or try it in somewhere else than live table
PPS. if you're not skilled enough, you can always pay someone to do it