Advertisement
Guest User

Untitled

a guest
May 22nd, 2015
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. 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
  2.  
  3. --complete-insert
  4.  
  5. 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