après copie du contenu du répertoire mysql d’un serveur vers un autre pour corrigé les évolutions du format
mysql_upgrade --force -uuser -ppassword
Réplication
slave my.cnf
slave-parallel-threads=4 server-id = 03 relay-log-index = /home/mysql/mysql_log/slave-relay-bin.index relay-log = /home/mysql/mysql_log/slave-relay-bin replicate-do-db = base1 replicate-do-db = base2 replicate-do-db = base3 replicate-ignore-table = base1.table_pas_ok replicate-ignore-table = base2.table_pa_ok slave-skip-errors = 1236,1146,1032
master show master status; -> noter file et pos exmaster1-bin.030648, 50302757 slave STOP SLAVE; change master to master_host='hostname', master_user='user_copy', master_password='user_pass', master_port=3306, master_log_file='master1-bin.030648', master_log_pos=50302757, master_connect_retry=10; START SLAVE;