Search code examples
mysqlsqlbackup

How to mysqldump WITHOUT dropping any tables

Normally, when I backup the database, I run a command like this:

mysqldump -uuser -p -hhost -Ddatabase > C:\TEMP\db_2018-04-05.sql

Inside that file, there are DROP table statements. This is normally fine, but I've modified my localhost to have a different schema than the production database.

If I execute this file, it will blow away the important changes to the database schema on my localhost.

All I need is the INSERT statements. Is there any flag I can pass mysqldump to achieve this?

Solution

  • Include the command for the mysqldump ignore the structure.

    mysqldump --no-create-info ...