Skip to content

Instantly share code, notes, and snippets.

@adrianosaaquino
Created March 12, 2015 15:54
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 adrianosaaquino/12b7dd95aff77434b8fc to your computer and use it in GitHub Desktop.
Save adrianosaaquino/12b7dd95aff77434b8fc to your computer and use it in GitHub Desktop.
MySql - Create/Restore DUMP with structure and data
Create dump.
$ mysqldump -uroot -proot schema_name > file.sql
Restore dump.
$ mysql -uroot -proot schema_name < file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment