ERROR 1189: Net error reading from master

If you encounter a ERROR 1189: Net error reading from master when running the MySQL command LOAD DATA FROM MASTER to set up replication, you might check 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 blind alley before I checked the disk.

Comments

cstdenis's picture
cstdenis on April 9, 2004 - 16:11 Permalink

You can’t load data from master on innodb tables. Change them temporarily to myisam to do the load, or do a file copy insted.