have you verified that the number of columns match? That the data types are matching as well?
-----Original Message----- From: rmck [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:01 PM To: [EMAIL PROTECTED] Subject: LOAD DATA ? Hello, My Load data command seems not to load data into my db: mysql> load data local infile '/opt/week/ip.0311100440' into table logs.Nov03 ignore 2 lines; Query OK, 1 row affected (0.66 sec) Records: 48273 Deleted: 0 Skipped: 48272 Warnings: 48273 mysql> I have plenty of space where my data files are.. Can someone point me in the right direction to see why it is skipping those.... the table looks ok mysql> show table status; +--------------------+--------+------------+-----------+----------------+--- ----------+-----------------+--------------+-----------+----------------+--- ------------------+---------------------+---------------------+------------- --------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +--------------------+--------+------------+-----------+----------------+--- ----------+-----------------+--------------+-----------+----------------+--- ------------------+---------------------+---------------------+------------- --------+---------+ | Nov03 | MyISAM | Dynamic | 72426930 | 112 | 8140043192 | 1099511627775 | 5872661504 | 112 | 83656882 | 2003-11-06 07:19:13 | 2003-11-12 12:23:12 | 2003-11-12 10:04:36 | max_rows=1000000000 | Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
