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

    Merging Tables in 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
    Oct 2009
    Cross reference the two tables to see what's missing in your live one compared to your backup.

    Then just append those rows.

    If your live table auto-incs the primary key, they should be missing from your live table anyways. Just re-insert them and it should be fine.
    Owner AS14442 Canadian Web Hosts Since 2002
    █ 24/7 365 Support, 100% Network Up-time Guarantee
    █ Web Development Specialists (E-Commerce, Inventory, Design) Reliable, Affordable VPS Servers and Web Hosting. IPv6 Available

  3. #3
    Join Date
    Jan 2010

    can you explain me little bit more. so that i can follow your steps

Similar Threads

  1. Merging 2 Databases
    By zippyhosts in forum Programming Discussion
    Replies: 4
    Last Post: 05-27-2011, 08:47 PM
  2. Help merging two mysql tables
    By acctman in forum Programming Discussion
    Replies: 1
    Last Post: 02-15-2006, 08:54 PM
  3. possible to join 2 tables from 2 databases?
    By grabmail in forum Programming Discussion
    Replies: 4
    Last Post: 01-08-2006, 04:13 PM
  4. merging 4 databases into 1?
    By t3chb0yg3n13 in forum Programming Discussion
    Replies: 3
    Last Post: 04-30-2005, 05:15 PM
  5. Merging 2 databases into one.
    By Salvatore in forum Hosting Software and Control Panels
    Replies: 4
    Last Post: 05-26-2004, 11:47 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