1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Rep Power
    I have dumped a database into a file dump.sql using mysqldump.

    Now I want to reload it onto another server with the same database, but older, but I only want newer records to be added, will it automatically do this? Or will I need to wipe the current one, then create it anew using the dump file?

    Do i use mysql database < dump.sql, and do I need to use any options?
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Caro, Michigan
    Rep Power
    You'll need to drop the existing databases, then import the dump file.

    You might have to specify a username and passoword when importing...

    mysql -uuser -ppass database < file.sql

    ---John Holmes...

Similar Threads

  1. restoring dump from 7.2 to 7.3
    By pablo.gosse in forum PostgreSQL Help
    Replies: 2
    Last Post: April 29th, 2003, 02:09 PM
  2. Problem with restoring a dump file. HELP ME!!!!
    By hopstream in forum MySQL Help
    Replies: 4
    Last Post: April 12th, 2003, 07:52 AM
  3. NT Registries and dump files (*.reg)
    By Jessman72 in forum Perl Programming
    Replies: 0
    Last Post: December 12th, 2001, 02:36 PM
  4. MySQL dump mystery
    By Jhan in forum MySQL Help
    Replies: 0
    Last Post: August 20th, 2001, 07:40 AM
  5. Replies: 7
    Last Post: May 9th, 2001, 12:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo