Solved

LOAD DATA FROM MASTER

Posted on 2004-03-31
7
615 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 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