[ensembl-dev] Problem importing huge file into MySQL

Toni Hermoso Pulido toni.hermoso at crg.cat
Fri Apr 13 17:53:49 BST 2012


Al 04/11/12 12:17, En/na Dan Sheppard ha escrit:

>
> Another option is that the temporary filesystem which MySQL is planning
> to use is not actually large enough (tmpdir= in my.cnf) to contain the
> temporary files. If your tmpdir is set to /tmp and you're on a system
> which reveals via df that /tmp is a dinky tmpfs type affair it may well
> be worth changing it.
>

Hello,

we finally made it work by defining another MySQL tmpdir location with 
far more free space.

Thanks to all who replied,

-- 
Toni Hermoso Pulido
Bioinformatician

Bioinformatics Core Facility
http://biocore.crg.cat
CRG - Centre de Regulació Genòmica (Room 439)
Parc de Recerca Biomèdica de Barcelona (PRBB)
Doctor Aiguader, 88
08003 Barcelona

toni.hermoso at crg.cat
Phone: +34 93 316 02 02





More information about the Dev mailing list