https://blog.liuts.com/index.php zh-cn https://blog.liuts.com/post// root <admin@yourname.com> Sat, 22 Sep 2007 07:18:04 +0000 https://blog.liuts.com/post// 从)无密码SSH访问;
二、添加热备用户权限：
grant select,reload,LOCK TABLES on *.* to backup@localhost identified by 'pass'
三、备份SHELL
#!/bin/bash BACKUP_SERVER="192.168.100.2" BACKUP_USER="mysql" MYSQL_USER="backup" MYSQL_USER_PASS="pass" 　　 MYSQLHOTCOPY=/usr/local/mysql/bin/mysqlhotcopy # Change to MySQL data directory cd /usr/local/mysql/data 　　 # Create an array with all directories in the MySQL data directory # The directory name presents the database name in MySQL. ARRAY=`find * -type d -prune` for DATABASE in `echo $ARRAY` do     # Create backup from database     $MYSQLHOTCOPY --method='scp -Bq -i /home/foo/.ssh/identity'  --user=`echo $MYSQL_USER` --password=`echo $MYSQL_USER_PASS` \         $DATABASE `echo $BACKUP_USER`@`echo $BACKUP_SERVER`:/usr/local/mysql/data/$DATABASE done
Tags - mysql , 热备 ]]> https://blog.liuts.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://blog.liuts.com/post//#blogcomment