public
Created

MySQL backup (saving engine used for table creation)

  • Download Gist
gistfile1.sh
Shell
1 2
# 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

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.