To back up your MySQL database, the general syntax is:

    1. sudo mysqldump -u[user] -p[password] [database_name] > [filename].sql

    To restore a MySQL backup, enter:

    1. mysql -u[user] -p[password]
    2. create database [database_name];
    4. mysql -u [user] -p [database_name] < [filename].sql

    How to periodically backup MySQL Automatically
    https://www.youtube.com/watch?reload=9&v=ECi4s1JXLNo

    1. 编写脚本
      1. #!/bin/bash
      2. YEAR=`date +%Y`
      3. MONTH=`date +%m`
      4. DAY=`date +%d`
      5. cd ~/backup
      6. mkdir -p $YEAR/$MONTH/
      7. mysqldump -uroot -p****** dingtalk > $YEAR/$MONTH/$YEAR-$MONTH-$DAY-backup.sql

    备份docker 中MySQL脚本

    1. #!/bin/bash
    2. mkdir -p ~/backup/$(date +"%Y/%m/")
    3. docker exec -it dingtalk_mysql_1 mysqldump -uroot -p*** dingtalk > ~/backup/$(date +"%Y/%m/"%Y-%m-%d-%H:%M)-backup.sql
    • docker exec 要执行多个命令时 bash -c “xxxx”
    • 要给shell 脚本添加执行权限 chmod +x backup.sh
    1. crontab -e 添加定时任务
      1. 0 1 * * * exec `/bin/bash  /home/ubuntu/backup/backup.sh`