数据库热备份成功一例

从216同步到211成功：
216:
log-bin = mysql-bin
log-bin-index = mysql-bin
server-id = 1
binlog-do-db = dabing
sync_binlog = 0
max_binlog_size = 500M
GRANT REPLICATION SLAVE ON *.* TO 'mysqlmysql'@'121.14.157.211' IDENTIFIED BY 'pidlfaxiont';  
 
211
server-id = 2
master-host = 125.90.2.21
master-user = 'mysqlmysql'
master-password ='pidlfaxiont'
replicate-do-db = dabing
master-connect-retry = 20
skip-innodb
relay-log = relay-bin
log_slow_queries
long_query_time = 1
log_long_format
report-host = host216
slave-skip-errors = all
 
                                  server-id不超过32
 
主压缩数据。主启动
从删除掉旧的，拷贝压缩文件。解压新的。 从启动
 
mysql> show slave status\G;
 
Slave_IO_State: Waiting for master to send event
Slave_IO_Running: Yes
Slave_SQL_Running: Yes