Skip to content

Instantly share code, notes, and snippets.

@megamvb

megamvb/mysql.sh

Last active August 11, 2016 14:34
Show Gist options
  • Save megamvb/ba31c9c4fc64dfa7dca70a833fe725e5 to your computer and use it in GitHub Desktop.
Save megamvb/ba31c9c4fc64dfa7dca70a833fe725e5 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL export and import commands
Raw
mysql.sh
### exportar
$ mysqldump -u nome_do_usuario -p nome_do_banco > nome-temporario.sql
# (vai solicitar a senha do banco de dados a ser exportado)
### importar
$ mysql -u nome_do_usuario -p nome_do_banco_para_IMPORTACAO-do_backup < nome-temporario.sql
# (no comando acima, os dados de acesso são do banco para importação do backup)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment