How to merge dB into my xenforo forum

[Dotgician]

So I have a xenforo forum but how do I merge the users, forum posts, etc from another dB to my forum? Both are xenforo db

 

[Deleted member 29780]

Personally I’d install two XenForo installations then import the one installation into one. Haven’t done this but I think it will work

 

[Dotgician]

even though its a different domain name?

 

[Deleted member 29780]

Yes. Is it on same server?

 

[Dotgician]

Yeah but then you would have to delete the tables in order to input the new DB right?

 

[Deleted member 29780]

you shouldn’t have to

 

[Dotgician]

Will i need to edit the file so the domain matches before i input the .sql file into my websites database?

 

[Deleted member 29780]

Nope you can do it through XenForo

 

[Dotgician]

Will give it shot and let you know.

 

[Dotgician]

Okay so basically I create a new DB in my phpmysql then upload DB file to it, and then go to importer like image. and fill in the boxes. Do you i need to fill them all in?
Can i just upload the file to my ftp and just use data directory?

 

[Deleted member 29780]

Create two installations, then upload the database to one of the installations via phpmyadmin.

 

[Dotgician]

for the source data confirguration form is that for my DB or the DB im trying to import?

 

[Deleted member 29780]

Right now just install both installations as you would any other XenForo install. Then we will go over that.

 

[Dotgician]

Well i dont have the domain of the old DB to create a new installation... Just created a new DB and imported the sql file to that.

 

[Deleted member 29780]

You could even do it localhost

 

[Dotgician]

should i create a subdomain for temp installation?

 

[Deleted member 29780]

just do it on your computer, get Xampp or wampp. Then create folders in www and add your installation inside them.

 

[Dotgician]

haha i have to figure out xampp, I just downloaded it

 

[Carlos X]

Assuming you have a database on your site already. And that database is linked to a website already. You don't need to do much other than just the following:

- Create new database.
- Import "old" database THERE. (phpmyadmin allows you to import directly from your local computer)
- Confirm everything is exact and correct.
- Write down the db name, db username, and password ("old" db)
- Go to ACP, find the importer, and when you're at the screen (Post #10 in this thread)
- Fill "old" database details you wrote down.
- If you have attachments/avatar files, write down the source of that path (and NOT the URL.)
-- If you don't, just create attachment/avatar filepath on URL #2.
- Press import. Wait. And enjoy.

DO NOT. UNDER ANY CIRCUMSTANCE, press the "maintain content ID's" button. That is only for websites that really, really wants to keep their database exactly as it was before - eg: importing from vBulletin, and keeping the old ID's so you can redirect old links there. (To keep the page rank.)

I would test with a fresh installation to see if your old database is correct, before finalizing.

 

[Dotgician]

Not going to lie a little lost can I just install it on a subdomain? Or a different root folder In my ftp?