Results 1 to 7 of 7

Thread: Merging Wordpress Databases

  1. #1
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 Posts

    Merging Wordpress Databases

    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?

  2. #2
    Andy101's Avatar
    Andy101 is offline Code Otaku
    Join Date
    Aug 2009
    Location
    Kanazawa
    Posts
    1,264
    Thanks
    173
    Thanked 305 Times in 232 Posts
    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.

  3. #3
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 Posts
    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?

  4. #4
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts
    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.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  5. Thanked by:

    abinowbhat (5 December, 2009), Hellas (6 October, 2009)

  6. #5
    garfish's Avatar
    garfish is offline I'm Not Sure.
    Join Date
    May 2009
    Posts
    848
    Blog Entries
    12
    Thanks
    155
    Thanked 57 Times in 54 Posts
    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

  7. #6
    TopDogger's Avatar
    TopDogger is offline Über Hund
    Join Date
    Jan 2009
    Location
    Hellfire, AZ
    Posts
    3,078
    Thanks
    347
    Thanked 914 Times in 698 Posts
    Quote Originally Posted by Will.Spencer View Post
    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!
    "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin


  8. #7
    abinowbhat's Avatar
    abinowbhat is offline Net Builder
    Join Date
    Oct 2009
    Location
    Cyberspace
    Posts
    166
    Thanks
    16
    Thanked 19 Times in 9 Posts

    Thanks a lot

    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.


    Quote Originally Posted by Will.Spencer View Post
    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.

Similar Threads

  1. Shrink Your Wordpress Databases by Deleting Revisions
    By Will.Spencer in forum Wordpress
    Replies: 1
    Last Post: 20 March, 2011, 13:37 PM
  2. MySQL Databases Hacked???
    By rome9t9 in forum Databases
    Replies: 6
    Last Post: 18 December, 2010, 14:28 PM
  3. [Announcement] AdminCommunity is Merging with NetBuilders
    By Will.Spencer in forum Announcements and Suggestions
    Replies: 15
    Last Post: 19 September, 2010, 19:16 PM
  4. [Free] Free Databases
    By SKULL in forum Content
    Replies: 0
    Last Post: 26 August, 2010, 21:47 PM
  5. Merging 2 different Proxy Script DBs
    By ProxySites.ca in forum Databases
    Replies: 3
    Last Post: 10 September, 2009, 20:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •