Skip to content

Instantly share code, notes, and snippets.

@kaosf

kaosf/mysql-backup.sh

Created November 20, 2015 13:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kaosf/9f1644c61df6870c4c25 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kaosf/9f1644c61df6870c4c25 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-backup.sh
mysqldump -u root -p -x --all-databases > backup.sql
mysql -u root -p < backup.sql
# ref. http://phpspot.net/php/pgmysqldump%E3%81%A7%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97%EF%BC%86%E5%BE%A9%E5%85%83.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment