MySQL 主從複製

標籤：

0.常用命令

 

12345678

刪除表中所有資料truncate 表名;reset master; 清除所有的bin-log日誌show master status;查看授權使用者show grants for [email protected];重啟Mysqlpkill mysqld

 1.Mysql授權  

12	grant all on *.* to ‘user1‘@192.168.10.2 identified by ‘pass‘;select user,host,password from mysql.user;

 2.Mysql的主從複製 

123	change master to master_host=‘192.168.10.1‘, master_user=‘slave‘, master_password=‘test.com‘, master_log_file=‘mysql-bin.000007‘, master_log_pos=334;start slave;show slave status\G

 3.Mysql手工備份  

1	/usr/local/mysql/bin/mysqldump -uroot -p123 test -l -F ‘/tmp/test.sql‘

 4.Mysql bin-log日誌手工恢複 

1	/usr/local/mysql/bin/mysqlbinlog --no-defaults mysql-bin.000002 | /usr/local/mysql/bin/mysql -uroot -p123 test

 5.Mysql資料庫恢複  

1	/usr/local/mysql/bin/mysql -uroot -p123 test </tmp/test.sql

MySQL 主從複製