Skip to content

Instantly share code, notes, and snippets.

@rgo
Created February 1, 2012 01:20
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rgo/1714364 to your computer and use it in GitHub Desktop.
Save rgo/1714364 to your computer and use it in GitHub Desktop.
MySQL backup (saving engine used for table creation)
# I'm using --create-options to get all the info about table creation (i.e. engine=InnoDB)
$ mysqldump -u foobar -p --single-transaction --create-options <database> > file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment