MyBB Community Forums

can I restore a thread that is deleted by accident?

if you have database backup with that deleted thread then it is possible to restore that thread

yes i have the database backup
how can i do this?

Setup XAMPP for localhost, go to DB in phpmyadmin and upload your old backup. Once you find the deleted thread & copy paste it on your live forum.

replies here might help

i tried to restore the forum by uploading the backup that was created 2 days back but strange thing is that it created 102 tables in sql and currently i have 129 , even if i download it directly from files of my host, it did this and when i download the uppload of mybb admin it does the same why is so..
just because files are missing... i can not even upload older restore.

---

how to restore only posts and thread table from the database?

restoring of entire backup is not suggested.

you have to get a single row of deleted thread from the threads table
and many rows of posts table which belong to that thread.

if deleted thread id is X then

select * FROM `mybb_threads` WHERE `tid` = X

above query gets the content related to the thread

below query fetches the posts data belonging that thread

select * FROM `mybb_posts` WHERE `tid` = X

output of above queries from the database backup should be imported to existing database

i managed to save both files but how to import it to the database now i don't know.

^ if you are using phpMyAdmin then you can use import tab at right side of the database page (see image)

[attachment=36256][attachment=36257]

ok i did the same... thread has come but me not able to view it.