Skip to content

Instantly share code, notes, and snippets.

@thiagolopes-dev

thiagolopes-dev/comandos

Last active May 11, 2021 00:46
Show Gist options
  • Save thiagolopes-dev/614811e8e1b2e99a4e9b34d6beb63fe1 to your computer and use it in GitHub Desktop.
Save thiagolopes-dev/614811e8e1b2e99a4e9b34d6beb63fe1 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Command Line Export and Import Database
Raw
comandos
#Considerando que tenha o caminho de seu MySQL Server no Path de váriaveis de ambiente para uso dos comandos,
sem a necessidade de informar o caminho absoluto do mysqldump.exe em todas execuções.
Comandos abaixo:
#Export All Databases
mysqldump -uuser --routines --triggers -ppassword --all-databases --single-transaction --quick --lock-tables=false > c:\tmp\full-backup-.sql
#Export Database Selected
mysqldump -uuser -ppassword --routines --triggers --single-transaction --quick --lock-tables=false suadatabase > suadatabase-bck.sql
#Export Database Table
mysqldump -c -uuser -ppassword --routines --triggers --single-transaction --quick --lock-tables=false suadatabase suatable > C:\tmp\suadatabase.suatable.sql
#Import
mysql -uroot -p database < c:\tmp\suadatabase.sql
#Import Database Table
mysql -u root -p teste < C:\tmp\suadatabase.suatable.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment