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.
mysqldump --skip-triggers --compact --no-create-info -u <username> -p <password> <database> <tables>
Recent Comments