ERROR 1189: Net error reading from master

Peter Rukavina

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

Submitted by cstdenis on

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.

Add new comment

Plain text

  • Allowed HTML tags: <b> <i> <em> <strong> <blockquote> <code> <ul> <ol> <li>
  • Lines and paragraphs break automatically.

About This Blog

Photo of Peter RukavinaI am . I am a writer, letterpress printer, and a curious person.

To learn more about me, read my /nowlook at my bio, listen to audio I’ve posted, read presentations and speeches I’ve written, or get in touch (peter@rukavina.net is the quickest way). 

You can subscribe to an RSS feed of posts, an RSS feed of comments, or a podcast RSS feed that just contains audio posts. You can also receive a daily digests of posts by email.

Search