VocabReminder
Easily build a great vocabulary without studying! Now on the App Store!
Click here for more info about the app

Dump MySQL Database without Drop Table Syntax

       

Output .sql file for MySQL but without the drop table syntax before table name use the --skip-add-drop-table flag


mysqldump -u root -p database_name --skip-add-drop-table --skip-lock-tables > database_name.sql

Tagged w/ #databases #flags #mysql #mysqldump #syntaxdatabases