Discussion

This error can happen while executing the LOAD DATA FROM MASTER statement because of a couple of reasons. It could happen if a non-MyISAM table was loaded. LOAD DATA FROM MASTER works 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.