Few Thousand Posts Lost

Unfortunately we've lost 4 months posts. I have a more recent backup which will bring us up to 1 month of lost posts.

I was upgrading the board, I had backed up everything and decided that the new version of unreal portal was horrible because it didn't allow you to navigate to the end of a thread and didn't show which threads had new posts so I dropped the database tables only to find out that shitty PHPMyAdmin had missed half the backup out. I restored it with a database file I found from like February and merged that with the recent backup of the members tables so that the members database fields are up to date.

I have no fucking clue why I used PHPMyAdmin to backup the DB because I always use the shell due to reliability and I so shoulda backed up the upgraded DB, but I guess I just learnt my lesson.

Unfortunately most of the last months posts are permanently lost. I'm not sure it's a massive issue though.

I apologise for the inconvencience.

so my post count will basically be reset to zero.

after all my hard work! Image file not present in the recovered backup

but its all good G. we will all make it somehow

EDIT: looks like my post count is still good

Member data is fine, just the post and thread tables got lost.

sweet. so everything is upgraded now? or is this a process that will take a while?

No, as I said I didn't like the new versions portal. It had shitloads of features which were paramount missing. One good thing that came out of this is I found the table which was preventing us admins changing peoples user groups, banning them and so on

Shit happens mate.

As long as the site still works, all is good.

Your posts always make me feel better

It's like being cuddled by a big gay hairy man.

as long as my post count is ok then Image file not present in the recovered backup

Shall I even bother restoring the 1 month old backup? Aint much point because most old posts will drop off the portal fairly soon, right?

I wouldnt bother. like you said, most old post will eventually fall off the portal.

You cock G.

Haha, I know. The ACP SQL issues have been fixed by myself though Image file not present in the recovered backup

What? Really? You cant be serious!? So let me get this straight, everything in ACP works again?

If so fuck the posts.

Image file not present in the recovered backup Image file not present in the recovered backup

Yep, I isolated it to a table called ibf_forum_perms which was missing, I simply manually created the table and copied a hierarchy from another forum and bingo

OMG I can finally sort out all the shit I wanted to. First things first. De-mod Baz.

Yeah, poor Baz, he was a good mod too. Awfully big shoes to fill. Image file not present in the recovered backup

(I have big feet)

I miss baz

No worries about the lost posts at least from my part.

Yeah man at least the forums still work and we all have eachother!

Can we do something about the arcade though? Image file not present in the recovered backup

We need more arcade games!, theres only like four that keep the score.

All in good time

Man mysql sucks especially when mixed with phpmyadmin lol
ive stopped using phpma. now, always fucks up my shizzle. lol
anyway man no worries about the posts as long as stuff is on the mend.

it's like a time travel back to February.

Baz died?

haha, nah something like he forgot his password and just cant be arsed to bother with hgf

MySQL doesn't suck, silly

I just shoulda known not to trust a PHP based tool to properly backup my data. This is the way it should be done:

External image not preserved — inspect source: http://upload.homegrownforums.com/thumbs/opt1185135234z.jpg

And nothing of value was lost.

Well mysql is a great idea yes but I hate using it cos phpma has scarred me for life. lol
it didnt always let me login either. :-(
But I use the mysql thing in my Cpanel now n its fine. lol