I am having a terrible time getting a text file imported. I've been working on this for about a week and finally have given up.
Hi, I am trying to get a file called mactable.txt imported into a table, OUI, which resides in a database called MACTABLE. Here are the commands that I am using with the results of the commands. And the first and last few lines of the mactable.txt file. I have removed all unnecessary characters. The only thing in this file is numbers and letters. 0-9 and A-Z. Nothing else. But I still get 6942 warnings, which is twice as many records in the file. The manufacture info does not import into the file, only the OUI data. RedHat 8 Dell Poweredge 350 Pentium III 850 512 RAM Thanks in advance. Leonard ------------------------ mysql> use mactable Database changed mysql> CREATE TABLE oui (oui CHAR(9), manufacturer VARCHAR(30)); Query OK, 0 rows affected (0.00 sec) mysql> LOAD DATA LOCAL INFILE "mactable.txt" INTO TABLE oui; Query OK, 3471 rows affected (0.02 sec) Records: 3471 Deleted: 0 Skipped: 0 Warnings: 6942 ------------------ 08 00 2B DIGITAL EQUIPMENT CORPORATION 08 00 2C BRITTON LEE INC 08 00 2D LAN TEC INC 00 00 00 XEROX CORPORATION 00 00 01 XEROX CORPORATION 00 00 02 XEROX CORPORATION 00 00 03 XEROX CORPORATION 00 00 04 XEROX CORPORATION 00 00 05 XEROX CORPORATION 00 00 06 XEROX CORPORATION 00 00 07 XEROX CORPORATION 00 00 08 XEROX CORPORATION 00 00 09 XEROX CORPORATION 00 00 0A OMRON TATEISI ELECTRONICS CO 00 00 0B MATRIX CORPORATION . . . 08 00 8D XYVISION INC 08 00 8E TANDEM COMPUTERS 08 00 8F CHIPCOM CORPORATION 08 00 90 SONOMA SYSTEMS 08 BB CC AK NORD EDV VERTRIEBSGES MBH 10 00 5A IBM CORPORATION 10 00 E8 NATIONAL SEMICONDUCTOR 80 00 10 ATT BELL LABORATORIES AA 00 00 DIGITAL EQUIPMENT CORPORATION AA 00 01 DIGITAL EQUIPMENT CORPORATION AA 00 02 DIGITAL EQUIPMENT CORPORATION AA 00 03 DIGITAL EQUIPMENT CORPORATION AA 00 04 DIGITAL EQUIPMENT CORPORATION ----------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
