mysqldump excluding drop table

Run the following command to create mysql dump without drop statement

mysqldump -hHOST -p -uroot --skip-add-drop-table --no-data -e DATABASE  > DATABASE.sql

Leave a Reply

Your email address will not be published. Required fields are marked *