Improve company productivity with a Business Account.Sign Up

x
?
Solved

LOAD DATA FROM MASTER

Posted on 2004-03-31
7
Medium Priority
?
641 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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

595 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