Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
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