General mysqldump excluding drop table January 3, 2019 Pramod T P Leave a comment 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