Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010

    Merging 2 Databases


    i have an Vbulletin Database file. recently i have deleted some ids in the site and by deleting the ids, there posts, polls and other stuff also got deleted. i have the backup of the database before deleting the id. right now i want to retrieve there ids and there corresponding posts.
    i have a database that is running live in the site . so is there any way to merge the 2 database, so that the ids which got deleted can only be retrieved ?

  2. #2
    Join Date
    Feb 2004

    bit of an up hill task, but you need to study the mysql tables and work out which tables are involved in the users and posts.. then select all the posts and user id's into a third DB, and then import those into the live DB.

    Have you tried posting your question to the vbulletin forums ?


  3. #3
    Join Date
    Jan 2010
    i guess we have a option to merge the database, so that only deleted tables and posts will be merged to the live database.

    if there is an option like this, can anyone help me

  4. #4
    Join Date
    Jan 2004
    Id use php for this. Check if the row exists or not and add your insert query.

    Not difficult at all.

  5. #5
    Join Date
    May 2006
    New Zealand
    Head over to the Vbulletin forums, they have would have more experience than the users here
    █ | Brad - Hoopla Hosting - Email or add me to Gtalk! brad [at]
    █ | Web Hosting New Zealand - Reseller Hosting - cPanel - Zurmo Hosting - Softaculous - CloudFlare
    █ | VPS - SolusVM - E3-1230 - RAID10 - 1Gbit

Similar Threads

  1. merging 4 databases into 1?
    By t3chb0yg3n13 in forum Programming Discussion
    Replies: 3
    Last Post: 04-30-2005, 05:15 PM
  2. Merging 2 databases into one.
    By Salvatore in forum Hosting Software and Control Panels
    Replies: 4
    Last Post: 05-26-2004, 11:47 PM
  3. Merging Connections
    By Centralized in forum Hosting Security and Technology
    Replies: 5
    Last Post: 11-25-2002, 12:59 PM

Posting Permissions

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