Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

LOAD DATA FROM MASTER

Posted on 2004-03-31
7
Medium Priority
?
625 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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
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…
Suggested Courses
Course of the Month11 days, 21 hours left to enroll

916 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