MySQL restoring a database via mysqldump - Does it overwrite the different destination tables?

mysql backup mysqldump restore
TMM picture TMM · Mar 29, 2011 · Viewed 9.4k times · Source

I am using mysqldump to backup a database containing several tables (say tables D, E, F). I use the following command: mysqldump -uuser -ppassword SourceDatabase > file.sql to backup these tables.

I would like to know if I restored this backup, would it overwrite other tables? For example, if I have a database DestinationDatabase, containing tables A, B and C, and after running the command "mysql -uuser -ppassword DestinationDatabase < file.sql", would I lose the tables A, B and C on the destination database (and be left with just D, E and F) or would I be left with A, B, C, D, E and F (with the original tables present in DestinationDatabase left untouched)?

Thanks in advance, Tim

Answer

The Scrum Meister picture The Scrum Meister · Mar 29, 2011

With the default options, it will not delete tables A, B and C. It will however overwrite (delete current data that is not in the backup) tables D, E and F.

To see the list of available options see here.

Related questions

How to take complete backup of mysql database using mysqldump command line utility

How can I make a complete backup of mysql database using mysqldump? When I am making a backup, my tables from specified database are only getting backed up. The procedures and functions are not. Here's the backup command I am …

Read More
mysqldump with create database line

I'm in the process of moving my files onto another computer, and one thing I would like to do is to transfer the data in my MySQL database. I want to dump the databases into .sql files, but also have …

Read More
restore all mysql database from a --all-database sql.gz file

I've backed all my mysql databases with he following command mysqldump -u root -ppasswod --all-databases | gzip > all.sql.gz just wanted to know will I be able to restore all of the database with following command gunzip < alldb.…

Read More