Problem using MySQL LOAD INFILE

hi, I have a products table with the following structure

CREATE TABLE IF NOT EXISTS `products` (

  `id` int(50) NOT NULL AUTO_INCREMENT,
  `productname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `merchanturl` text NOT NULL,
  `imageurl` text NOT NULL,
  `price` varchar(10) NOT NULL,
  `original` varchar(10) NOT NULL,
  `currency` varchar(12) NOT NULL,
  `extrafields` text NOT NULL,
  `feedid` varchar(25) NOT NULL,
  `category` varchar(255) NOT NULL,
  `merchant` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `productname` (`productname`),
  FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM;

I use mysql LOAD INFILE command to import delimited data files into this table. it has 4 million records now. when i import more data using LOAD INFILE I got the following error

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I am not able to access the products table after that.How can i improve the performance of the table. some data files are more than 100MB in size.I have another 4 million entries which need to import to the table.

Please suggest methods to avoid these issues

Thanks, Sree

ansaurus

tags:

views:

answers:

Problem using MySQL LOAD INFILE

related questions