November 29th, 2000, 11:44 AM
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?
November 29th, 2000, 01:08 PM
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