mysql命令杂记

yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker


yum install perl-ExtUtils-MakeMaker  perl-CPAN   perl-CPAN perl-CPANPLUS -y


yum install perl-Config-Tiny  perl-Time-HiRes  Log::Dispatch



 grant replication slave on *.* to 'repl'@'10.26.100.%' identified by 'yueying9sedefwwe' ;
 grant replication slave on *.* to 'root'@'10.26.100.%' identified by 'yueying9sedefwwe' ;

CHANGE MASTER TO MASTER_HOST='10.26.100.51',MASTER_USER='repl', MASTER_PASSWORD='yueying9sedefwwe',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=1;


 /dbdata/awdb01/bin/mysqldump --master-data=2 --single-transaction -R --triggers -A  -uroot  -p> /root/awdb01_all.sql


CHANGE MASTER TO MASTER_HOST='10.26.100.51',MASTER_USER='repl', MASTER_PASSWORD='yueying9sedefwwe',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=1115