[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.


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

Thanks to all who replied,

Toni Hermoso Pulido

Bioinformatics Core Facility
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