Skip to content

Instantly share code, notes, and snippets.

@ontiuk

ontiuk/mysql_command_line_dump.tst

Last active August 20, 2016 13:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ontiuk/019d5647f053523dc4a2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ontiuk/019d5647f053523dc4a2 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Command Line Dump: mysqldump
Raw
mysql_command_line_dump.tst
/* Command Line: Dump Table Contents. One insert per line */
mysqldump --complete-insert --lock-all-tables --no-create-db
--no-create-info --skip-extended-insert --password=XXX -u XXX
--dump-date dump_table_name > dump_table_data.sql
/* Command Line: Dump Table Contents. One insert per line. Root SSH no pwd */
mysqldump --complete-insert --lock-all-tables --no-create-db
--no-create-info --skip-extended-insert --dump-date dump_table_name > dump_table_data.sql
/* Command Line: Dump Table Contents & Structure. One insert per line. Root SSH no pwd */
mysqldump --complete-insert --lock-all-tables --skip-extended-insert --dump-date dump_table_name > dump_table_full.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment