Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement