Need a database pro! combine 2 SQL databases...

  • Hello Vbulletin,

    I have a tough question for the Database pro's out there.

    I run a small site - www.stangpower.com (http://www.stangpower.com) - There is another small Mustang related site and his renewal is coming up so I thought it would be cool to merge our boards. This way we can split the VB license on my server.

    Anyhow, he has 100+ users I have 250+, he has threads, I have threads, ect.. Is there a way to combine his vbulletin.sql with mine and not loose any data? I have thought about it for weeks but I am not sure if it is possible. I did a search here and on VBulletin.org but could not find anything. Basically I want all his threads, and all his users combined with mine into one large database.

    Any ideas or comments?

    Ian


  • Hello Vbulletin,

    I have a tough question for the Database pro's out there.

    I run a small site - www.stangpower.com (http://www.stangpower.com) - There is another small Mustang related site and his renewal is coming up so I thought it would be cool to merge our boards. This way we can split the VB license on my server.

    Anyhow, he has 100+ users I have 250+, he has threads, I have threads, ect.. Is there a way to combine his vbulletin.sql with mine and not loose any data? I have thought about it for weeks but I am not sure if it is possible. I did a search here and on VBulletin.org but could not find anything. Basically I want all his threads, and all his users combined with mine into one large database.

    Any ideas or comments?

    Ian
    not possible with 2.2.x but if you both have separate licenses.. you can copy the database and restore 2 copies into separate databases and then delete the unecessary threads/users/posts for respective forums


  • Thanks for the help! That hack looks like what I need.

    I am going to try it on my own private internal server and see if it works out.

    Thanks!

    Ian


  • Theory:

    If the database you're moving isn't going to be used, you could probably use some DROP COLUMNS to get rid of areas like userid, etc -- pretty much anything that has an auto increment value -- and do a mysqldump into a text file of said tables. Then on your other database (the one you're trying to merge with), it's as easy as ". your_users_file.sql" If you dumped the text file with complete inserts (-c), it should automatically generate new userid/posts/signature/avatar/bla bla bla fields while keeping the dumped columns (such as username, password, etc.) intact when you merge them. It's a pretty dirty task, but the only one I can think of at the moment that'll do what you want it to do.

    Threads would be a bit different, since threadid, and postid are both primary keys (afaik), and I really wouldn't know how to go about that without doing it myself a few times (which I can't do, since I don't have any non-used vBulletin databases around...)


  • Is http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=786 what you're looking for?


  • Tricky. It would be possible, but you would have to manually change all references to userIDs, threadIDs, postIDs, etc. so they do not clash between the two forums

    Sean :)


  • isnt there a hack to merge to forums?







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Need a database pro! combine 2 SQL databases... , Please add it free.

    8 January 2009 | cameltoepants.com | edit