Page 1 of 1

Hi need some help inserting topic tru database

Posted: Wed Jan 10, 2018 12:22 pm
by androidcribs
Hi where could find viewtopic.php?t=xxxx where xxxx is I want to add because I deleted it due to the Google flagged. And I want to restore it again but via database. Any one can help me? thanks
I lost my backup and want to restore it manually via database or phpmyadmin.

Re: Hi need some help inserting topic tru database

Posted: Wed Jan 10, 2018 12:42 pm
by warmweer
androidcribs wrote:
Wed Jan 10, 2018 12:22 pm
Hi where could find viewtopic.php?t=xxxx where xxxx is I want to add because I deleted it due to the Google flagged. And I want to restore it again but via database. Any one can help me? thanks
I lost my backup and want to restore it manually via database or phpmyadmin.
First of all, since you have no backup and the topic has been deleted the question is whether you still have the data of that topic and its posts (printscreen, or written down)?
If the answer is yes then you can restore the topic and its post by making a new topic, giving it the old topic_title, making the posts and giving them the correct post_titles. What you have just done will then be available in the database. In the database, Find the topic, and then the posts you have just made and change the relevant fields to the old values (post_id, topic_ID user_IDs, post_times, etc...). If you don't have the old date/time values, you can still antedate the posts so that the chronology remains.
However, before starting this, write down everything you have to do (with data) so that if you make a mistake, you can easily find and repair the errors.

It the answer is no then those posts are permanently lost I fear. (if you didn't close the page in your browser you can still go back and see the old page, and perhaps the data is still in the cache).

Re: Hi need some help inserting topic tru database

Posted: Fri Jan 12, 2018 4:51 am
by androidcribs
warmweer wrote:
Wed Jan 10, 2018 12:42 pm
androidcribs wrote:
Wed Jan 10, 2018 12:22 pm
Hi where could find viewtopic.php?t=xxxx where xxxx is I want to add because I deleted it due to the Google flagged. And I want to restore it again but via database. Any one can help me? thanks
I lost my backup and want to restore it manually via database or phpmyadmin.
First of all, since you have no backup and the topic has been deleted the question is whether you still have the data of that topic and its posts (printscreen, or written down)?
If the answer is yes then you can restore the topic and its post by making a new topic, giving it the old topic_title, making the posts and giving them the correct post_titles. What you have just done will then be available in the database. In the database, Find the topic, and then the posts you have just made and change the relevant fields to the old values (post_id, topic_ID user_IDs, post_times, etc...). If you don't have the old date/time values, you can still antedate the posts so that the chronology remains.
However, before starting this, write down everything you have to do (with data) so that if you make a mistake, you can easily find and repair the errors.

It the answer is no then those posts are permanently lost I fear. (if you didn't close the page in your browser you can still go back and see the old page, and perhaps the data is still in the cache).
Thanks I laready fixed it. Thank you for your response Sir!