Nov 30
I got myself a original Angry Video Game Nerd title poster. It has been draw by Mike Matei and its signed by James and Mike.
I got myself a original Angry Video Game Nerd title poster. It has been draw by Mike Matei and its signed by James and Mike.
If you replication slave reboots and you get error messages like:
ERROR 1201: Could not initialize master info structure, more error messages can be found in the MySQL error log
Fix i found for it was manually adding the master.info back to slave:
STOP SLAVE RESET SLAVE CHANGE MASTER TO MASTER_HOST=’your_master’, MASTER_USER=’your_login’, MASTER_PASSWORD=’your_password’, MASTER_LOG_FILE=’log_file’, MASTER_LOG_POS=log_position START SLAVE
If you get errors, try:
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1 START SLAVE
Source: http://blog.bit-matrix.com/2008/11/19/mysql-replication-error-1201-could-not-initialize-master-info-structure/