Skip to content

Instantly share code, notes, and snippets.

@healthy-tree

healthy-tree/some-docker-restore-backup-mysql.sh

Last active July 12, 2023 02:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save healthy-tree/1fffe7e3c8afa084a5e101bac870b0d0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save healthy-tree/1fffe7e3c8afa084a5e101bac870b0d0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. healthy-tree renamed this gist Jul 12, 2023. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → some-docker-restore-backup-mysql.sh
    View file
    File renamed without changes.
  2. healthy-tree revised this gist Oct 28, 2021. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,5 @@
    docker exec -it mysql mysqldump -u**** -p*** --all-databases > mysql_dump_yyyy_mm_dd.sql
    # backup
    docker exec -it container mysqldump -u**** -p*** --all-databases > mysql_dump_yyyy_mm_dd.sql

    # restore
    cat backup.sql | docker exec -it container mysql -u**** -p**** --all-databases
  3. healthy-tree created this gist Oct 28, 2021.
    1 change: 1 addition & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    docker exec -it mysql mysqldump -u**** -p*** --all-databases > mysql_dump_yyyy_mm_dd.sql