# mysqldump --add-drop-table option
--add-drop-table
is a mysqldump
option that is used to write a DROP TABLE
statement before each CREATE TABLE
statement.
mysqldump --add-drop-table > my_backup.sql
When executing the command from above, the dump file will have a DROP TABLE
statement written before each CREATE TABLE
statement.