Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

LOAD DATA FROM MASTER

Posted on 2004-03-31
7
616 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connect MySql database to wordpress site 3 80
MySQL left join performance 4 44
setup wamp server for first time 2 83
Mysql Left Join Case 10 70
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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