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
You can’t load data from
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.
Add new comment