Hello Everyone.. Quick Question on Restoring MySQL Table..

Discussion in 'Site & Server Administration' started by nhatle84, Jun 11, 2011.

0
  1. #1
    Just a problem I ran into..

    My NEW database currently have just 10 members and the OLD database contains around 250.. I've successfully restored the the OLD database but it also replaced/overwrites the 10 new ones..

    So basically I wanted to add/includes back 250 members without overwriting the 10 new ones..

    Any advice and suggestion is highly appreciative..

    Thanks in advance!
    Nhat Le
     
    nhatle84, Jun 11, 2011 IP
  2. stardust.x7

    stardust.x7 Active Member

    Messages:
    369
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    90
    #2
    You need to use import facilities with phpmyadmin. Make sure table ID not clash with existing IDs.
     
    stardust.x7, Jun 11, 2011 IP
  3. Cucumba123

    Cucumba123 Well-Known Member

    Messages:
    1,403
    Likes Received:
    34
    Best Answers:
    3
    Trophy Points:
    150
    #3
    Change the primary key of the rows in the tables of the new database to something different than the ones in the old database.
    Tell me if you need help with this, I can help you out free of charge.
     
    Cucumba123, Jun 11, 2011 IP
  4. selvamurali

    selvamurali Peon

    Messages:
    69
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    it its not working you may use bigdump.php file. it use for import high volume of databases
     
    selvamurali, Jul 21, 2011 IP