[base] Re: Unable to load data into database

[Carl T. <ca...@th...>]

joe writes:

> I am having trouble loading raw data sets into the database.  Base seems to 
> successfully parse the file, but then cannot seem to load it.  This may be 
> the same problem as the local-infile option file, but Base does not seem to 
> have trouble loading other information into mysql tables.   Therefore I do 
> not think it is a problem with permissions, or evidently with disk space.  Is 
> there something fundamentally different in the way that BASE loads parsed raw 
> data rather than anything else into the mysql tables?  Could my problem be 
> the local-infile option (I too used the RPM).  

LOAD DATA LOCAL INFILE is used in just a few places, where a large
number of rows are inserted at the same time: result files, plates,
gene lists, when jobs finish, and possibly a few others.
If you're using an RPM binary version of MySQL, and you haven't
done anything to get LOCAL INFILE to work, I'd guess that that's
causing the trouble, but I can't be sure without seeing the errors
that you get (most importantly any logged SQL errors).
If LOCAL INFILE is the problem, make sure mysqld is started with
--local-infile=1. (and test that it works, too)

//Carl

-- 
 Carl Troein - ca...@th...
 http://www.thep.lu.se/~carl/
 BASE developer - http://base.thep.lu.se