Merging two sql databases

[madnessmotors]

Recently I lost all of the posts made by my username on my phpBB forum in an accidental pruning.

I just found a backup of my database on the server from just before that pruning but, I don't want to lose what has been added since then, is there a way to add the backup without overwritting everything?

[Shane]

Short answer, yes.

Long answer, (well medium) there should be a recovery option to not over write already existing records. If you find it, recover the old data over the existing data with the option turned on. This should just add the old posts.

Now, do not do this without a new backup of your existing database.

Don't attempt it if you have never done a recover before.

I don't know how technically profecient you are. If you are at all uncomfortable, get professional help (e.g. don't blame me ..... this is just a technical answer.)

..... Shane

[madnessmotors]

I looked around in phpMyAdmin and I don't see any options for recovery or in the phpBB Admin Control Panel.

This is mySql by the way if that matters.

[jatar_k]

When I have had to rebuild lost threads and topics in phpbb I have done it by hand just using the good old command line.

How much information did you lose? You could install the backup and extract the missing threads/posts and then change the id's and reinsert them into the existing db. This is not easy to do and would probably take a fair amount of time depending on how much you lost.

[madnessmotors]

I lost over 1000 of my posts plus, the topic replies to the topics that I started.

[bobnew32]

Well with the backup that you have, just open it up in notepad and just remove all the "insert into" crap, place it into another file and upload. It'll do it all for you. Just make sure you dont see any drop tables or anything, but for my cpanel backups it inserts it for me. Modify it like I said and you should be fine.