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

Revisions

  1. thiagolopes-dev renamed this gist May 11, 2021. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → comandos
    View file
    File renamed without changes.
  2. thiagolopes-dev created this gist May 11, 2021.
    20 changes: 20 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    #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