Posts Tagged ‘flags’

Dump MySQL Database without Drop Table Syntax

Posted 05 Feb 2010 — by admin
Category Databases

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