Log in

View Full Version : loading certain tables from previous backup


feras
07-14-2007, 05:49 AM
Hi,
I setup my server to take cpanel backups of my board weekly.
Anyways, long story, buy 1 of the admins deleted all the threads in 1 of the forum section.

I've reloaded the backup on a different location (so it doesnt overwrite the current site, since there's alot of new content and what not) and am logged into the admincp in the backup

Is there anyway to copy over just those forums, or anything of that nature?
thanks

Dismounted
07-14-2007, 06:11 AM
The only way would probably be to go into the backup's text and remove everything apart from those entries.

feras
07-14-2007, 06:18 AM
dismounted, I didnt quite understand what you meant.

The backup has an older version of the site, but it has the posts in the forum that got emptied.

The current site doesnt have the posts in that forum, the forum is blank.

So in essence, I'm trying to put just those posts from the backup into the current forum.

Also, I'm pretty good at coding and would probally understand most of what you say if you get technical. I could do this custom, but I'd have to code alot, check ids, etc, isnt easy work.

thanks

Dismounted
07-14-2007, 06:43 AM
Open up the SQL backup in a text editor and you'll see ;).

feras
07-14-2007, 07:29 AM
it's basically a mysql dump correct? All the create tables and inserts?

It wouldnt be that easy to distinguish what I need and what I dont. There has to be something pre-written to help me do this

Dismounted
07-14-2007, 10:37 AM
Search for one of those MySQL restore scripts, they probably have a parsing feature.