Skip to content

Instantly share code, notes, and snippets.

mysqldump -u tymyshoe -p password --host=hublogik.crmf51oxrvmc.us-east-1.rds.amazonaws.com hublogik_test --add-drop-table --single-transaction --complete-insert > database_dump.sql
--complete-insert
By default mysqldump includes INSERT statements built to *follow* create statements. So the assume all the columns match. If you break up your schema & data you could potentially have a mismatch. This option makes sure the INSERT statemens included in the dump specify column names. So if they don't match, you'll get a proper error message.