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