Skip to content

Instantly share code, notes, and snippets.

@hnxvc

hnxvc/shell_script_backup_restore_mysql

Created July 1, 2019 16:24
Show Gist options
  • Save hnxvc/0c7fa3975cb9a6e1e0df9b648199e4e5 to your computer and use it in GitHub Desktop.
Save hnxvc/0c7fa3975cb9a6e1e0df9b648199e4e5 to your computer and use it in GitHub Desktop.
Download ZIP
Backup and restore mysql
Raw
shell_script_backup_restore_mysql
# Backup
mysqldump -uroot -p*** hoablog --single-transaction --quick --lock-tables=false > /root/backup/mysql/hoablog-$(date +%F).sql
cd /root/backup/mysql
git add .
git commit -m "Backup file"
git push origin master
#Restore
mysql -u root -p*** hoablog < /root/backup/mysql/hoablog-2019-06-08.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment