Solved

LOAD DATA FROM MASTER

Posted on 2004-03-31
7
612 Views
Last Modified: 2008-03-17
Hi,

  I am doing a LOAD DATA FROM MASTER, and I get:

ERROR 1189: Net error reading from master

I had this problem before, and i remember I remove the ibdata1 file, restarted and then it worked.

I am NOT using Innodb tables anywhere and I think this is why my LOAD DATA FROM MASTER is failing (because of the ibdata1).

I removed the ibdata1 file from the master and now when I do LOAD... I get:

ERROR 1188: Error from master: 'Can't open file: 'admins.InnoDB'. (errno: 1)'

How do I fix these errors?

Ben
0
Comment
Question by:bptacek
  • 4
  • 3
7 Comments
 

Author Comment

by:bptacek
ID: 10724418
I found out one of my DBs I was not using was using InnoDB.  I removed this and now I am not getting the error.  I am not sure if this is what is causing the first error though???

If someone can shed some light on the problem then I will still be offering the points.

Ben
0
 
LVL 9

Expert Comment

by:Alf666
ID: 10724854
"LOAD DATA FROM MASTER" only works with MyISAM tables.

So, yes, if one of your table is non MyISAM (in this case innoDB), it won't work :

http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html
0
 

Author Comment

by:bptacek
ID: 10725013
Yes, I understand that, but is that what the error means?  And if so... how do I get mysql to stop from creating ibdata1?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 9

Expert Comment

by:Alf666
ID: 10725180
Yes. The error means that it's trying to apply a process to an unsupported type of table.

you can do a :
drop table ibdata1;

(under mysql).

It might give you an error because you already deleted the file by hand, but it should work.

0
 

Author Comment

by:bptacek
ID: 10725210
i don't think ibdata1 is a table.  /var/lib/mysql/ibdata1.  It doesn't belong to any database, so hence you cannot drop it as a table.

Also, even though i deleted the ibdata1 by hand, it comes back everytime I restart the MySQL process.
0
 
LVL 9

Accepted Solution

by:
Alf666 earned 500 total points
ID: 10725306
Sorry. My mistake. Yes. It's a description file for all innoDB tables.

Disable innoDB completely by adding the following line to your server's my.cnf :

skip-innodb

If you don't know where your my.cnf is located, or want to create one if none exists, do :

mysqld --help

You will find something like :

Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf

Then, delete the ibdata1 file, and restart your server. With a bit of luck, it should not re-appear.
0
 

Author Comment

by:bptacek
ID: 10725350
Perfect, works like a charm.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Importing and exporting data Magento 1.x ? 4 71
xampp tool 12 30
MySQL  on Tomcat 8 30
How to import sql database into mysql workbench 18 12
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now