MySQL-Scheduled backup

• Create a backup directory here, take/root/bak/mysql as an example:

  cd   mkdir bakcd bakmkdir mysql

• Touch an SH under/usr/sbin:

  cd /usr/sbintouch myDBbackup.sh

  The contents are as follows:

  #!/bin/bash#Name:myDBbackup.sh  backupdir=bak/mysql  time=` date +%Y%m%d%H%M `mysqldump --login-path=local appleague | gzip > $backupdir/myDB$time.sql.gz

• Mysqldump does not support entering passwords directly on the command line, you need to do the following:

  mysql_config_editor set --login-path=local --host=localhost --user=username --password

  Then you can sign in:

  mysql --login-path=local  -e "statement"

• Set timed execution
  Maybe you can write in/etc/crontab, and/etc/init.d/crond restart.
  But you can also enter crontab-e into vim and write the following format:

  0 2 * * * sh /usr/sbin/myDBbackup.sh

• Manual recovery:

  gunzip  xxx.gzmysql -u root -p --default-character-set=utf8use myBDsource /root/bak/mysql/xx.sql

MySQL-Scheduled backup