Table of Contents
Updated
If you are facing error 1201 hy000, the main information structure could not be initialized on your PC, this guide can help you fix it.
I noticed that you didn’t specify MASTER_LOG_POS in the Change to master.Les command
If users set up MySQL replication, they must specify it explicitly in the /etc/my.cnf file
[mysqld]server id=1
Updated
Are you tired of your computer running slow? Annoyed by frustrating error messages? ASR Pro is the solution for you! Our recommended tool will quickly diagnose and repair Windows issues while dramatically increasing system performance. So don't wait any longer, download ASR Pro today!
[mysqld]server id=2
Because the master is MySQL 5.0.67, and you often load the same data into the slave, the CHANGE MASTER command is also used for your convenience:
master in business changeMASTER_HOST='192.168.1.15',MASTER_USER='replication1',MASTER_PASSWORD='******',MASTER_LOG_FILE='mysql-bin.Is 000001',master_log_pos=98;
Here’s what you need to know in order for others to set up slaves
CREATE DATABASE rolando;
SHOW SLAVE STATUSG
on the slaveBROWSE DATABASES;
on the slaverolando
database should look like SHOW DATABASES;
on the slaveDue to an issue, one of my cleanups is out of sync with the master.
When I tried to run the slave, I get the error:
mysql> is a slave 1201: start;
The ERROR Info structure could not be initialized, and many more error messages can be found in the MySQL log.
070719 15:53:36 Error Destination protocol could not be found during relay protocol initialization.
and googled and got some information that experts say they tried this in terms of
mysql> MAIN change In master_log_file=’sn-sj-1-bin.021′,master_log_pos=275410644;
ERROR 1201: Failed to initialize main info structure, many error messages can be found in the MySQL error log.
One of the brand new slaves not synchronized with version 4.0.18 is version 4.0.18.
The above hurdle is due to a version issue?.
In general, if the problem is in the version, such as making the slave synchronize with the master, there is no advantage in changing to the version.
If the problem is usually not the version, how can I fix it?
Help me please.
Edited 4 times. Last modified on 26.07.2007 04:04 mostly by Prakash Nallusami.
ERROR 1201 (HY000): Primary initialization of secondary structure information failed. Check the MySQL error log
for any error messages.
121223 10:00:39 [ERROR] Failed to open log ‘relay./mysqld-relay-bin.000001’ (relay_log_pos 4)
121223 [ERROR] 10:00:39 Destination protocol cannot exist when relay initialization protocol
Copyright notice. All articles on this blog are subject to BY-NC-SA cc 4.0 unless otherwise noted.
Hello Receiving Team
We found a very unusual error in the /var/log/mariadb/mariadb.log file on the main MariaDB server using the main package script.
The error we get on mariadb-relay-bin. 000001 also exists in Mysql documents and owner directory, permissions are correct.
flag vii -la /u/mysqldata/mariadb-relay-bin.000001
-rw-rw—-. 1 mysql mysql 264 Sep 7 03:21 /u/mysqldata/mariadb-relay-bin.13:54:55 000001
171003 [ERROR] Error opening relay log ‘./mariadb-relay-bin.000001’ (relay_log_pos 4)171003 [ERROR] 13:54:55 Failed to find test target during relay protocol initialization171003 [ERROR] 13:54:55 Failed to initialize message structure master [Note]171003 13:54:55 Event Scheduler: Two events loaded
Please help us resolve this issue.
Reply
Hello
To solve this problem “Could not initialize our own main information structure”ruru”, perform a short reboot, the slave and the main device will change the information when cleared. Following are the complete steps to connect mariadb
1) SLAVE RESET;
2) REPLACE MASTER WITH MASTER_HOST=’
3) START SLAVE;
I also quickly saw the problem in my configuration and solved it using the steps above.
If the steps above did not resolve your issue, please provide the following information:
Speed up your computer today with this simple download.Ошибка 1201 Hy000 Не удалось инициализировать главную информационную структуру
Błąd 1201 Hy000 Nie Można Zainicjować Głównej Struktury Informacji
Erreur 1201 Hy000 N’a Pas Pu Initialiser La Structure D’informations Principale
오류 1201 Hy000은 마스터 정보 구조를 초기화할 수 없습니다
Errore 1201 Hy000 Non Può Inizializzare La Struttura Delle Informazioni Master
Error 1201 Hy000 No Se Pudo Inicializar La Estructura De Información Maestra
Fel 1201 Hy000 Kunde Inte Initiera Huvudinformationsstrukturen
Fout 1201 Hy000 Kan Hoofdinfostructuur Niet Initialiseren
Erro 1201 Hy000 Não Pôde Inicializar A Estrutura De Informações Mestre
Fehler 1201 Hy000 Master-Info-Struktur Konnte Nicht Initialisiert Werden