Error 1189 Mysql
Contents |
Hi, I have some problems here with two mysql servers, version 4.1.8; on the master server, binary logs are activated, free disk space is mysql error codes list not null; root@db0:~# ls -l /repl/mysql/data/master.* -rw-rw---- 1 mysql mysql 1814256
Mysql Sqlstate
2005-02-08 11:43 /repl/mysql/data/master.000001 -rw-rw---- 1 mysql mysql 16 2005-02-07 22:28 /repl/mysql/data/master.index root@db0:~# df -h /repl/mysql/data/
Mysql Error Php
Sys. de fich. Tail. Occ. Free. %Occ. Monté sur /dev/hd0/repl0 4,0G 607M 3,4G 15% /repl0 the correct grant has been typed on the master server to
Mysql Errors Log
allow the slave to connect and replicate; (launched with --skip-name-resolve) mysql> grant replication slave, file on *.* to repl@stripped identified by 'pass'; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) now I change the "master to", and ask for the mysql errors and solutions master (in production), to give his data to the slave; mysql> change master to MASTER_HOST='db0', MASTER_USER='repl', MASTER_PASSWORD='pass', MASTER_LOG_FILE='master.000001'; Query OK, 0 rows affected (0.03 sec) the only thing I can get is: mysql> load data from master; ERROR 1189 (08S01): Net error reading from master Any ideas ? is this a bug in 4.1.8 ? Regards, Olivier Kaloudoff CKR Solutions Open Source Mandelieu, France http://www.ckr-solutions.com Thread• ERROR 1189 (08S01): Net error reading from masterOlivierKaloudoff8Feb • Re: ERROR 1189 (08S01): Net error reading from masterGlebPaharenko8Feb • Re: ERROR 1189 (08S01): Net error reading from masterOlivierKaloudoff8Feb • Re: ERROR 1189 (08S01): Net error reading from masterBastianBalthazarBux8Feb • default valuesEmmettBishop8Feb • Re: default valuesJeffSmelser8Feb • Re: default valuesMichaelStassen9Feb • Re: ERROR 1189 (08S01): Net error reading from masterOlivierKaloudoff8Feb © 1995, 2016, Oracle Corporation and/or its affiliates
LOAD DATA FROM MASTER statement because of https://lists.mysql.com/mysql/179549 a couple of reasons. It could happen if a non-MyISAM table was loaded. LOAD DATA FROM MASTER works http://www.mysqlab.net/knowledge/kb/detail/topic/replication/id/5751 only with MyISAM engine. It can also happen if a recoverable network error occurs. Solution If this error is thrown, make sure all tables on the master are MyISAM. If so, retry running the SQL statement. In case of databases containing InnoDB tables or other engines, use mysqldump for slave initialization.
(7 messages) 1. mysql error 2005-02-08 Re: ERROR 1189 (08S01): Net error reading from master mysql Olivier Kaloudoff 2. 2005-02-08 Re: ERROR 1189 (08S01): Net mysql error code error reading from master mysql Bastian Balthazar 3. 2005-02-08 Re: ERROR 1189 (08S01): Net error reading from master mysql Olivier Kaloudoff 4. 2005-02-08 Re: ERROR 1189 (08S01): Net error reading from master mysql Gleb Paharenko 5. 2005-02-08 ERROR 1189 (08S01): Net error reading from master mysql Olivier Kaloudoff Configure | About | News | Addalist | SponsoredbyKoreLogic
2 configurations one for primery and another one for secondary. $$$$$$$$$$$$$ Primery Server( Master Side) $$$$$$$$$$$$$ 1) Edit /etc/hosts.allow and add this line ( you MUST change this IP’s for yours !! ) Mysql : 10.0.0.1 2) Edit /etc/mysql/my.cnf or /etc/my.cnf
$$$$$$$$$$$$$$$ Comment this below lines $$$$$$$$$$$$$$$$
bind-address = xxx.xxx.xxx.xxx
skip-networking
####### Make sure this lines exists in the [mysqld] Section:
log-bin=mysql-bin binlog-do-db=database1 binlog-do-db=database2 etc.,
server-id = 1 3) Now lets move to mysql using a power user like root xD
mysql> GRANT ALL ON databasename.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here';
mysql> FLUSH PRIVILEGES;
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO repl@'%' IDENTIFIED BY 'put_some_pass_here'; 4) restart MySQL service $$$$$$$$$$$$$$$$ Client Side $$$$$$$$$$$$$$ 5) Edit my.cnf …. In my case located at: /etc/my.cnf * I’m going to show just a what you need the my.cnf file contains much more info.
#### Add this lines or modify them
log-bin=SOME_NAME-relay-bin
server-id = 2
#### This number increases when you add more than one SLAVE os CLIENT to the MASTER server
master-host = 192.168.50.8
#### Put the Hostname or IP from your MASTER server
master-user = repl
master-password = put_some_pass_here
replicate-do-db=databasename1 replicate-do-db=databasename2 save and close the file. you have to run this query to set the SLAVE. Before execute the query. you have to check the MASTER_LOG_FILE and MASTER_LOG_POS in master log(mysql> show master status\G)of primary server mysql -u root -p mysql> CHANGE MASTER TO MASTER_HOST=’Ip_of_your_master’, MASTER_USER=’repl’, MASTER_PASSWORD=’some_password’, MASTER_LOG_FILE=’mysql-bin.000001′,