====== MySQL - Exclude DROP and CREATE TABLE From mysqldump ======

How do you dump data from a mysql database table without the drop and create tables showing up before the inserts?

The following solution will just give you a list of insert statements.  Simply use the options **–skip-triggers –compact –no-create-info**.

Here is an example.

<code bash>
mysqldump --skip-triggers --compact --no-create-info -u <username> -p <password> <database> <tables>
</code>