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

    Join Date
    May 2000
    Posts
    14
    Rep Power
    0
    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
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    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, 03:09 PM
  2. Problem with restoring a dump file. HELP ME!!!!
    By hopstream in forum MySQL Help
    Replies: 4
    Last Post: April 12th, 2003, 08:52 AM
  3. NT Registries and dump files (*.reg)
    By Jessman72 in forum Perl Programming
    Replies: 0
    Last Post: December 12th, 2001, 03:36 PM
  4. MySQL dump mystery
    By Jhan in forum MySQL Help
    Replies: 0
    Last Post: August 20th, 2001, 08:40 AM
  5. Replies: 7
    Last Post: May 9th, 2001, 01:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo