i am doing the replication from master to slave in MySQL. Replication works fine with MyISAM engine. But when i use "InnoDB" engine, by giviing "LOAD DATA FROM MASTER;" i am getting the error as "ERROR 1189 (08S01): Net error reading from master".
Even i gave the the privileges SELECT,SUPER and RELOAD in master. But still i am getting this?
Please how can we fix this error?. Otherwise tell me how we can configure replicate the data using "InnoDB" engine?.