I wasn’t bored, but I don’t think I could have found a better way to spend my time anyway
Few days ago I chatted with a fellow forum admin about the possibility to merge our two forums. www.WomenOnlyForums.com would get some new members and content and we’d grow together from now on.
Everything seemed to be OK. I told her I would start tweaking something, look for topics that already mention this and in few days we might make the switch. She was fast enough to give me a first dabatase dump for me to work on.
I have to thank Lord for the brains he gave me (this time at least) and the inspired thought of setting a test forum. I was almost on the verge of working on the main forums and then realized it’s too serious to toy around with.
So my first night meant creating the 2 databases and importing the data. Creating the test forum was a good idea in the end … I was able to see that the main database backup was working and I could also see the results when trying the merge.
The second day meant looking for the merge script and tweaking it. And the first set of some ugly errors. I read the info I could many times and tried to adjust. At the end of the second working day I had the feeling that maybe .. I won’t make it. I also knew then that we have 2 different databases (mine heavily modded with so many supplementary tables and columns) and the other one with its share of modifications too. While I tried to sleep I made is as a plan to compare the 2 databases and try to make them more compatible.
The next 2 days meant more work into solving the errors. I had them all. And looked for some explanations and ways out while also learning some more about phpmyadmin and database structure. It was even more clear to me: I won’t make it. I have re-imported the databases so many times I was just sick of it. I wanted to quit tens of times, but I knew that I would make a fool of myself in front of my fellow admin who was willing to trust her forums and members to me.
It was Saturday in the morning. I woke up determined to finish it that day (I promised to do so days ago and few hours ago I asked the other admin to close the board entirely since I won’t need a second database dump. I just wasn’t able to go through it all again with a new database that needed re-importing of the columns that weren’t there in the first place. Her forum was closed for more than 1 day already and I was ashamed to tell her “Well, I wasn’t able to make it, do whatever you like with it.”
I went shopping (looks like it’s a good way for a woman to ease her mind
) and came home some hours after this. I opened phpmyadmin again and let the script make the merges and give errors until I spotted ALL the missing columns. I wrote all the code to insert them, emptied the databases again and did it all over again. I would go farther each time and have other new errors. After another set of errors I was able FOR THE FIRST TIME to have a flawless merge.
It was about the time I would close my main forum, announce my members of the downtime we’ll experience and then work on the merge on the official forum. I sent a mass email telling my girls we’ll have a surprise prepared and the forums would be down for few hours. I then backed up the main database once again, changed the info on the merge script and re-imported the data on the second database (teh one to be placed in my forums).
And … Error. Forgot to add a column and I had an error again. After I calmed myself down I re-dropped all the tables in both databases, re-imported them, imported the list of changes in the SQL option and hit the merge script again. IT WORKED. I screamed for joy and went to see my big forum. Took me some hours to make it all OK, move topics, re-open the forums, welcome the new people … but the main thing was that I did it. I merged two forums and proved to myself once again that I CAN DO IT.
And since this is the “romance” style story, here is the tutorial I made about this.
Share and Enjoy:
These icons link to social bookmarking sites where readers can share and discover new web pages.