|
General software and network General OS-independent software and network questions, X11, MTA, routing, etc. |
|
Thread Tools | Display Modes |
|
|||
MySQL database import not helpful
I am busy sanitizing a 250,000 record tab delimited database file. Each record has more than 50 fields.
After importing the file with the mysql util, the following is shown; Code:
Query OK, 231369 rows affected, 65535 warnings (6.12 sec) Records: 231369 Deleted: 0 Skipped: 0 Warnings: 5392 Code:
show warnings ; [snip] | Warning | 1366 | Incorrect integer value: '' for column 'xxxx_yyy' at row 1 | | Warning | 1265 | Data truncated for column 'first_name' at row 1 | | Warning | 1366 | Incorrect integer value: '' for column 'zzz' at row 1 | [snip] | Warning | 1366 | Incorrect integer value: '' for column 'id2' at row 13 | +---------+------+----------------------------------------------------------------+ 64 rows in set (0.01 sec) But as stated at http://dev.mysql.com/doc/refman/5.1/...-warnings.html Quote:
Code:
mysql> show variables like 'max_error_count' ; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_error_count | 64 | +-----------------+-------+ mysql> SET max_error_count=6000; Query OK, 0 rows affected (0.00 sec) mysql> SELECT @@max_error_count; +-------------------+ | @@max_error_count | +-------------------+ | 6000 | +-------------------+ 1 row in set (0.00 sec)
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump |
|
|||
Yes, that was exactly the case and that is how I fixed it.
The other error Incorrect integer value: '' for column 'id2' at row 13 was caused by importing an empty string into a int field. It should have been NULL.. The CSV used for import had a lot of empty fields like ,,,,.
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump |
Tags |
mysql data import |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Read Excel Data and store into Mysql Database using PHP | cksraj | Programming | 2 | 3rd June 2009 12:09 PM |
zfs import | terryd | FreeBSD General | 1 | 23rd November 2008 09:26 PM |
Roundcube Mail Can't Connect to MYSQL Database | jrs665 | OpenBSD Packages and Ports | 1 | 17th November 2008 03:54 PM |
import physical freeBSD into VMWARE (ESX) server as a vServer | ccc | FreeBSD General | 6 | 3rd October 2008 07:04 AM |
Changing encoding of text in MySQL database | stukov | Programming | 5 | 15th July 2008 09:48 PM |