Net Error Reading From Master
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 not null; root@db0:~# ls -l /repl/mysql/data/master.* -rw-rw---- 1 mysql mysql 1814256 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/ 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 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 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 Legal Policies Your Privacy Rights Terms of Use Contact Us Page generated in 0.012 sec. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
to see that your slave isn't suffering from a full disk. I fell into this trap and, thinking that the error was somehow network-related, spent a lot of time running down that https://lists.mysql.com/mysql/179549 blind alley before I checked the disk. Posted October 5, 2003 at 10:34 pm | 1 comment | Add a comment « PreviousNext » Comments cstdenis on April 9, 2004 - 16:11 You can't load data from http://ruk.ca/content/error-1189-net-error-reading-master master on innodb tables. Change them temporarily to myisam to do the load, or do a file copy insted. reply Add new comment Your name * E-mail * The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar. Comment * Notify me when new comments are posted All comments Replies to my comment Home page Search form Search Where am I? About ruk.caArchive (from 1999)RSS Feed (Posts)RSS Feed (Comments)RSS Feed (Podcast)Subscribe by EmailAbout Peter RukavinaContact Peter RukavinaPresentations, Speeches and RadioElsewhere on the webTravels
Member Hello, I need a help with mysql. I currently have two servers and i want on each server to run mysql with the same https://www.howtoforge.com/community/threads/mysql-2-servers-2-mysql-on-each-server-one-database.36463/ database\same content. is it a way to mirror mysql? please help me with that. my linux: centos5 mysql 5 Stephan, Jun 14, 2009 #1 id10t Member You want to look into replication id10t, Jun 14, 2009 #2 Stephan New Member id10t said: ↑ You want to look into replicationClick to expand... can you explain what it is and how to do it? Stephan, Jun net error 14, 2009 #3 robertlouwen New Member @ Stephan Falko wrote a easy to follow, two pages tutorial for mysql replication. You can find it here http://www.howtoforge.net/mysql_database_replication Good luck Robert robertlouwen, Jun 14, 2009 #4 Stephan New Member thanks guys. i'll try Falko tutorial Last edited: Jun 15, 2009 Stephan, Jun 15, 2009 #5 Stephan New Member mysql> LOAD DATA FROM MASTER; ERROR 1189 (08S01): net error reading Net error reading from master i get this error Stephan, Jun 15, 2009 #6 falko Super Moderator ISPConfig Developer Use a database dump instead of the LOAD DATA FROM MASTER method. falko, Jun 15, 2009 #7 Stephan New Member falko said: ↑ Use a database dump instead of the LOAD DATA FROM MASTER method.Click to expand... i did it, but the content not mirroring on slave mysql Stephan, Jun 16, 2009 #8 falko Super Moderator ISPConfig Developer Did you use this command to import the SQL dump on the slave? Code: mysql -u root -p