Professional Web Applications Themes

load data infile - deleted, warnings, skipped - MySQL

Hi, I just loaded 71,000 records using "load data infile" and when done it gave no warnings, but said it skipped 4. Is there any record anywhere of which 4 records didn't get loaded or any other info about it? I know about the show warnings, but didn't find any "show skipped" command? I have also searched all the server log files. I am using mysqld 4.1.11 and Innodb. I am assuming that either the data had some bad syntax, or that referential integrity wasn't met. I didn't "set foreign_key_checks=0" .. If the 4 records got skipped because of referential ...

  1. #1

    Default load data infile - deleted, warnings, skipped

    Hi,
    I just loaded 71,000 records using "load data infile" and when done it
    gave no warnings, but said it skipped 4. Is there any record anywhere
    of which 4 records didn't get loaded or any other info about it?
    I know about the show warnings, but didn't find any "show skipped"
    command?
    I have also searched all the server log files. I am using mysqld
    4.1.11 and Innodb.

    I am assuming that either the data had some bad syntax, or that
    referential integrity wasn't met. I didn't "set foreign_key_checks=0"
    ..

    If the 4 records got skipped because of referential integrity checks,
    will it say so, or does it always only give the message about
    "deleted:0 skipped:4 warnings:0"

    thanks in advance..
    Roshan

    roch77@gmail.com Guest

  2. Moderated Post

    Default Re: load data infile - deleted, warnings, skipped

    Removed by Administrator
    Bill Karwin Guest
    Moderated Post

  3. #3

    Default Re: load data infile - deleted, warnings, skipped

    Thanks a lot Bill for your reply. After reading your post, I decided
    to try to make sure my primary key was unique for each row. Sure
    enough I got 4 rows with duplicate entries, so that was my problem.
    Back to the drawing board to figure out the primary key.

    Roshan

    roch77@gmail.com Guest

Similar Threads

  1. LOAD DATA INFILE
    By Luca in forum MySQL
    Replies: 4
    Last Post: July 11th, 12:35 PM
  2. LOAD DATA INFILE problem
    By howachen@gmail.com in forum MySQL
    Replies: 3
    Last Post: June 10th, 05:56 PM
  3. Complex LOAD DATA INFILE
    By stefaan.lhermitte@agr.kuleuven.ac.be in forum MySQL
    Replies: 6
    Last Post: May 18th, 06:34 PM
  4. Load Data Infile question
    By bradfordh@gmail.com in forum MySQL
    Replies: 3
    Last Post: March 23rd, 04:53 AM
  5. help : LOAD DATA LOCAL INFILE
    By Dave in forum PHP Development
    Replies: 3
    Last Post: October 5th, 12:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139