Import SMF forum 1 to SMF forum 2 but stripped down

NoRad · January 31, 2005, 02:05:32 PM

Looks like I need to do the same type of process with the smf_topics first.

NoRad · January 31, 2005, 02:14:46 PM

Yeah, this totally screwed up my website. Glad I just made another backup 10 minutes ago. See, the problem here is that the topics and message ID's conflict with existing topic and message ids on the new forum.

NoRad · January 31, 2005, 02:42:04 PM

OMG I am not a lucky person. My backup restoration keeps timing out about 1/2 way through. I'm totally ******ed.

Ben_S · January 31, 2005, 03:20:03 PM

http://www.simplemachines.org/community/index.php?topic=18350.0

[Unknown] · January 31, 2005, 03:25:17 PM

I say this basically *EVERY TIME* someone brings up the subject of combining forums. It's like 5000 times more complicated than people want to expect it to be.

-[Unknown]

NoRad · January 31, 2005, 03:48:56 PM

Yeah, it really is. I appreciate the help of trying to make it work, but I think it's better left untouched. I thought that maybe a "stripped down" version would work. What frustrated was not the fact that it screwed everything up. I was upset because my backup was not restoring properly. I make it a point to do a backup before anything like this, especially after I lost a week's worth of posts last month from a stupid crash.

Once again, thank you everybody for trying to help me make this work. I highly advise not trying to do this unless you're a skilled SQL/PHP person. It's very complex.

Ben_S · February 01, 2005, 06:33:34 AM

Did you get your backup restored?

NoRad · February 01, 2005, 08:50:03 AM

Yes I did. What I had to do to make it work was go in with word pad and isolate just the database I was trying to restore. I cut everything else out of the file and saved it as another name. Then I restored and it worked.

Ben_S · February 01, 2005, 09:35:59 AM

Glad you got it back up, [Unknown]s tools in the link I posted may help in future

.

NoRad · February 01, 2005, 09:46:21 AM

Thank you. I was going to try those if the other method didn't work. I had already started on the restore when I saw your tools link, but those will surely come in handy. Thank you very much for the assistance.

carhartt · February 06, 2005, 10:44:47 AM

try a little bit with the "INSERT IGNORE INTO" option and the "repair errors" option in the admin menü. that helped me.

NoRad · February 06, 2005, 12:58:52 PM

Really... repair errors in mySQL or in SMF? Did you have the same problem I had before doing this?

I'm SCARED to try this again. lol

carhartt · February 06, 2005, 01:17:49 PM

try it on a seperate box and with backups.
cant tell the way, because i was just playing around... and suddenly it worked.

NoRad · February 06, 2005, 08:19:11 PM

I would think that by just adding like 10,000 to the ID and doing your method would work. Then the repair option would fix the ID fields or?

News:

Import SMF forum 1 to SMF forum 2 but stripped down