Help restoring forum posts...

Regular Joined: Jun 08, 2007 Posts: 54

Hello all, again.

So, I have gone and re-installed (after deleting the old RN distro 2.02 from the server) RN 2.10.01 and things good so far.....thanks Raven!

So, here is my dilemma (I've read in here, there is a way to do it but, I am not certain how to do it) I need to restore the forums posts and content and guides. I have the original back up of the site with all the old posts but I don't know exactly what to do with them and where to insert them in mysql.

I've tried bigdump but, it keeps timing out. This is after I removed all the "#----------" and "#", re-saved as "xxxxxx.sql", uploaded onto my server and tried to upload into mysql. times out.

I've tried just copying the posts and saving it as "posts.sql" then importing from mysql. It is a no go.

Am I even doing this right?

Any help would be great right now....thanks.

PHP v.4.3.11
mySQL v. 5
RN 2.10.01 (obviously)
CuteFTP Pro 8
or
FileZilla

Posted: Sun Jun 10, 2007 12:58 pm

Is there any reason why you didn't do a straight upgrade. i.e. upload and overwrite the files and then run the upgrade scripts? This way you would not need to try and import all the content again.

Posted: Mon Jun 11, 2007 7:22 am

I tried to upgrade. it failed. if you read my post in the upgrade from 2.02 to 2.10.01, you will see the full details of what happened.

I started this post because it is a "new" install of the program, therefore, I felt that it belonged in a new post. Sorry if I did this wrong.

However, I have been reading in this forum (when searching) on how to restore the database and the posts but I think a lot of the solutions were "pm'd" and not posted for public viewing.

If it is not possible, the I will start copying and pasting all the old posts/text from the old database into their appropriate forums. I was just hoping since I was able to create the forums by copying and pasting the "insert field" codes from the old database, that there was an easier way of restoring the posts/text.

Posted: Mon Jun 11, 2007 10:42 am

Sorry there are so many posts that sometimes it is difficult to make sure you read everyone and some do slip through. If you had posted a link to the original thread it would have helped, but never mind back to the problem in hand.

If you have a backup of the original database it should be possible to extract the tables you want to restore and install them using phpmyadmin.

I must admit I've only ever upgraded my sites and never tried to restore, so I will need to have a play. What you want to do should be possible though.

In the meantime if any of the other more experienced mods want to jump in and help please feel free.

jakec

Posted: Mon Jun 11, 2007 11:43 am

Hey jakec...no problem. Here is my original post:

http://www.ravenphpscripts.com/postt13582.html

I have read and researched and read some more...but the forums posts are not showing after I resync it. I wonder what I am doing wrong. It does show "topics/posts" but after resyncing, nothing is showing up in the forums....I am resyncing through the phpBB Administration.

How I did it was through phpmyadmin by going to:

phpmyadmin>database>table>SQL (run)>copy and paste from saved DB from 'INSERT INTO xxxxx_xxxx VALUES ('XXXXXXXXXXX.......)>GO>read and confirm message that mySQL displays

Now, like I said, when I tried to upgrade, the site just became...well...WACKY! Buttons were missing where they once were....can't login...displaying blank pages....even after altering xxxx.php files...nothing helped. My only last resort was to do a fresh install of the site, completely.

I would love it if some other mods stepped in and pointed me down the correct path....truly.

If all else fails, I think I will just cut and paste....into the forums as I do believe that this part IS the forum(s) post(s)?

nuke_bbposts_text

registered · Posted: Tue Jun 12, 2007 6:22 am

kittyprrrs, at this point, it is really difficult for us to know what you have done, how, and what state things are really in. (This is the hardest part of trying to support this stuff.)

What I suggest you do is get mySQLDiff, install it, and do a database comparison (structure) between a copy of your original 2.02 and what you have now and then let mySQLDiff give you the SQL to apply to your 2.02 database to make it match 2.10.01 (please make sure you have a saved off copy of your 2.02 database in case you need to restore it). Then try and copy over all your data, keeping in mind that 2.10.01 also came with some data, so you will have some "collisions" and you just need to figure out which to ignore and which to address.

Posted: Tue Jun 12, 2007 9:22 am

Thank you Montego, again.

I just want to share that..the site is up!

This is what happened. Long story short (or short as possible):

When I backed up the site, it was mysql 4.x. (done through the sites db backup)

When I re-created the sites db, I created it as mysql 5.x. (phpmyadmin)

Now, I read somewhere that mysql 5.x to 4.x sometimes are funky with one another so, when I completely deleted the site and did a fresh re-install, I slowly but surely copied every single "insert into xxxxxx values" into their appropriate headings (i believe spoon feeding was what someone called it here?). (phpmyadmin>select tables that you want to "feed">copy and paste the INSERT INTO XXXXX VALUES into the SQL [run queries block/window]>go)

when I was done with all that, I did the same with "nuke_users" only, there was a table dropped from 2.02 to 2.10. (mysql produced error of "table missing")

I hand typed all the users along with their e-mail addresses according to the "status" of registry (33=pinkdog@xxxxx.com, 2=blackdog@xxxx.com) as when I did it just random, I saw message in my inbox from someone who is NOT my brother. (yes, i did this through phpmyadmin under nuke_users>browse>edit users>change numbers from x-XX)

I then went back INTO phpbb admin (under sites admin>forums) and re-sync'd all the forums posts. Went back into the site and VIOLA! Such beautiful work of codes! Yay!!!!!

Thank you all for all the questions, hints, answers, flashlight...map! I did it...I really did it!

Ahh...now I can find some more modules/blocks/add-ona to make the site complete.

Thanks everyone...again!

Posted: Tue Jun 12, 2007 4:20 pm

Posted: Tue Jun 12, 2007 6:08 pm

kittyprrrs, uuuggghhhh... you have much more patience than I have. Good job!

Posted: Tue Jun 12, 2007 6:16 pm

hmmm...I do think I have my daughter to teach me that. Patience, truly....is golden. I am glad I am beginning to get it! (yes...db/php/mysql/patience)

Smack

since it is beaten into me everyday! ahahahahaha!