Previous Thread
Next Thread
Print Thread
Rate Thread
#280664 10/10/2004 11:01 PM
Joined: Mar 2003
Posts: 159
Member
Member
Joined: Mar 2003
Posts: 159
I was moving posts around and ended up deleting a thread instead of moving it. I do have a back up copy of the database, but don't want to restore the whole database due to several other posts being made within the couple of hours between me realizing what I did.

Any suggestions?

Sponsored Links
Joined: Mar 2000
Posts: 528
Junior Member
Junior Member
Offline
Joined: Mar 2000
Posts: 528
If you know the Thread number, you can search the backup file for that specific number.

If not, a snippet of content, or something will have to suffice. At that point you would just copy the entire line that says INSERT INTO w3t_Posts...

Joined: May 2001
Posts: 550
Code Monkey
Code Monkey
Offline
Joined: May 2001
Posts: 550
>copy the entire line that says INSERT INTO w3t_Posts...
...into the mysql query window in the administration panel and press "execute query"

Joined: Mar 2000
Posts: 528
Junior Member
Junior Member
Offline
Joined: Mar 2000
Posts: 528
LOL sorry, it was late, my kid started screaming from her bedroom.

Had to run and never got back to the PC to finish my thought!

Joined: Mar 2003
Posts: 159
Member
Member
Joined: Mar 2003
Posts: 159
This maybe a little more difficult, but the backup I have is the one done with phpmybackup and is in a .gz format. I have never been in this situation, so I have never needed to restore a backup.

Sponsored Links
Joined: Feb 2001
Posts: 169
Member
Member
Offline
Joined: Feb 2001
Posts: 169
If you are on Windows install WinZip and extract the .gz file. You'll have a .sql file. This one can be opened with a text editor and here you can find all the posts like this:

Code
<br /><br />('UBB1', 5711, 5710, 5705, 1039014180, 1039423440, '151.38.109.212', 'Re: A.P.O.', 'Il grande Wolf, vista l\'amicizia che lo lega ad Apo, per aiutarlo a passare meglio i giorni di convalescenza, gli regala un bel puzzle!Apo, guarito, chiama wolf e gli dice:<br />-Lele sono un genio, ci ho messo solo due settimane a finire il puzzle!<br />e Wolf -Genio!?ma se io ne ho uno uguale e ci ho messo due giorni, come fai a dire che sei un genio!<br />-ma se sulla scatola c\'è scritto da 2 a 3 anni....  <img border="0" title="" alt="[Un grande sorriso]" src="images/icons/grin.gif" />  <br />Auguroni Apo!!!!!!!!!!!!!!', NULL, '', 'O', 'yes', 'trophy.gif', 'y', 1, 0, 65, NULL, 0, 'markup', NULL, NULL, 461, '0', 0, NULL, 0, 'BIELLO', NULL, NULL, NULL, 0, 0, 0, 1),<br /><br />


Copy the correct one and execute it as sql command in your site.

Joined: Mar 2003
Posts: 159
Member
Member
Joined: Mar 2003
Posts: 159
Thanks a bunch !!

I got the 1st post back, which was the most important, but none of the other 3 pages of replies came back.

Joined: Mar 2000
Posts: 528
Junior Member
Junior Member
Offline
Joined: Mar 2000
Posts: 528
You would have to search your w3t_Posts 'archive' for every instance of that Original Post's number.

IE if the B_Number was 14423, then each post on that entire THREAD would have a B_Main of that same number. That should be all the posts in the entire thread.

If it was a large thread, you might spend some time finding them, but you would insert them exactly as you did the original post.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Pilgrim
Pilgrim
NH, USA
Posts: 190
Joined: June 2000
Forum Statistics
Forums63
Topics37,570
Posts293,915
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,829
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2022 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221129)