Merging Wordpress Databases

**garfish** · 19 September, 2009, 04:15 AM

i've bought a wp database from someone. i just wanted to ask if anybody have did something like combining it to another wordpress database and would did you do it please?

**Andy101** · 19 September, 2009, 11:00 AM

I think the best approach is to write a php script that inserts the new rows of data above the existing ones for each table but with the index values increased so they stack up on top of the existing data rows.

If you don't know what I am talking about you probably need to visit rent a coder or a similar site.

Of course back up your existing data before trying any of this.

Just some ideas off the top of my head.

**garfish** · 19 September, 2009, 18:34 PM

yayks! i dont have much to pay for a coder

how much would it cost?

i'm thinking if i''ll just install another wp and insert the database to it, then manually copy-paste its content to the wp site i'm concentrating. what dyou think?

**Will.Spencer** · 24 September, 2009, 06:51 AM

I'm not sure that I completely understand your requirement?

I've merged a lot of Wordpress blogs.

In your Wordpress Admin Control Panel, go to the Tools Menu and choose the Import option.

You will need a Wordpress WXR database dump from the old site. If you have only a MySQL database dump, you will need to install it into a Wordpress blog so you can export it as a WXR file.

**garfish** · 29 September, 2009, 23:25 PM

i did it. following what you said will. i search about WXR and it led me to lots of tutorials..

thanks. it didn't overwrite the old entries

**TopDogger** · 30 September, 2009, 00:39 AM

Originally Posted by Will.Spencer

I'm not sure that I completely understand your requirement?

I've merged a lot of Wordpress blogs.

In your Wordpress Admin Control Panel, go to the Tools Menu and choose the Import option.

You will need a Wordpress WXR database dump from the old site. If you have only a MySQL database dump, you will need to install it into a Wordpress blog so you can export it as a WXR file.

I just learned something new. I didn't know that this feature was built into WordPress. Thank you, oh wise one!

**abinowbhat** · 5 December, 2009, 14:41 PM

Hi!

I have been using Wordpress since a long time but did not knew that this features existed.

Thanks a lot for sharing the tips.

Originally Posted by Will.Spencer

I'm not sure that I completely understand your requirement?

I've merged a lot of Wordpress blogs.

In your Wordpress Admin Control Panel, go to the Tools Menu and choose the Import option.

You will need a Wordpress WXR database dump from the old site. If you have only a MySQL database dump, you will need to install it into a Wordpress blog so you can export it as a WXR file.