I have to say I second this - great work Julian, thanks!

Would like to ask the progress on this.

Thanks

Hi gmtalk.

Download the lastest version from here:

https://vborg.vbsupport.ru/attachmen...&postid=359490


And see if it works for you.... It *should* work using two different databases with different host/user/password... :)

Julian,

Silly question. I DLed the one that you linked and it was the same as the one that i had there. I have been trying this out on my test databases. I am importing over 10k users and 300k messages and when it was all said and done it just duplicated my forum that I was importing into.

So now I have 2 general discussion areas with the same posts etc. Thinking that I messed it up. I restored my database back to normal backups that I had. Both the database to merge into and the db that was to be merged.

I then redid the merge as before, but this time swapped my merger and mergee< is that a word > and it did the same but to the other database this time.

Now maybe I am missing something I am not sure. Shouldnt there be two entry areas one for the to db and one for the from db? On all versions that i have DLed from here it only has the one DB entry.

My server is as follows.

DB1: User: rooter Pass: pass DBName: test1
DB2: User: rooter Pass: pass DBName: test2

of course the User and Pass are the same, just not listing them here.

John

PS: yes i made sure that i had the right program. I am doing this from my laptop and not the desktop where i originally tried this.

So no need to clear my cache until i get home and try from the desktop.

john

Uhmmmm First, make sure you have the lastest version... No wait... I'm going to attach the lastest version here in this post, just to make sure.. :)

Ok.. Here's how it works... The database to merge into is the one you're using to run your currently vbulletin installation. You don't need to type the user / password for it, because the script have access to the database, as long as vbulletin is running fine.

Ok now, what's the host/user and password that you should fill at the start of the merge? It's the information for the SECOND database, the one you want to merge with your current vbulletin installation.

If this database is in the same server, you should fill similar values like the ones you have on your config.php. But you have the possibility to merge a database located on another server, by filling the correct host/user/pass and db name, and it should work.

Just send me a PM if you still have problems with the merger.


Here's the lastest version! :)

Link removed.

What tables does it exactly merge?

I have a 40mb db, and phpmyadmin keeps giving me the error when i try uploading the vbulletin.sql file that there was No SQL Query! So gonna try cleaning out some of the stuff and see what happens after.

Not sure if it's going to be helpful for you, but the script only reads the following tables:

attachment
forum
poll
post
privatemessage
thread
user
userfield

I'm not sure if it's the complete list of tables the script needs to read...

I am running in to EXACTLY the same problem...
It is just duplicating ALL the entries in the database.

I have vb 2.2.8 that I would like to import to a vb 2.3.0 forum, will this work since the database for 2.2.8 is different from a 2.3.0 forum database?

-WoodiE