Mysql use tmpdir, when ever there is any index creation. regards anandkl
On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote: > > Hi, > > I've been trying to import a 10G dump file using mysqlimport > and it is eventually failing because it runs out of tmpdir > space -- I get Errcode: 28. > > I was surprised that it was using a temp file at all. I've > looked in the documentation and other sources but have not been > able to find anything about this file. > > This is on v5.0.51. The table is innodb and has 75 columns with > 65% of them tinyint, 20% float, and the rest char,datetime,int. > The primary key is composite on two columns (int,char). > The data file that is being imported is on the database server. > > I'll try this again and monitor the status parameters to see what > it is doing, but I was wondering if anyone already knows? > > Thanks, > John > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >