Member Avatar for acakaliman

Hey all, I'm new-ish at MySQL and Navicat. I'm trying to import a file with about 1.16 million records and Navicat keeps "working" (I see the timer moving) but it actually stops processing records at 850,825 records. The log shows no errors whatsoever but I know there are many more records. Why is it not importing all records?

Here's the log:
[2011-09-21 09:37:24] [Msg] Import start
[2011-09-21 09:37:24] [Msg] Import type - Text file
[2011-09-21 09:37:24] [Msg] Import from - Y:\DistroPartner\EmailCampaign_ClassicActive.csv
[2011-09-21 09:37:24] [Msg] Create table [Classic_Active]
[2011-09-21 09:37:24] [Msg] Import table [Classic_Active]
[2011-09-21 09:42:41] [Msg] Processed:850825, Added:850825, Updated:0, Deleted:0, Errors:0
[2011-09-21 09:42:41] [Msg] Finished - Successfully]

I imported same file into MS Access and I get almost all records imported (42 have problems, 1,168,040 get created). I don't know how to figure this one out.

  • 4 Contributors
  • 4 Replies
  • 454 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for debasisdas

Practically impossible to guess anything out of this.

Member Avatar for acakaliman

Practically impossible to guess anything out of this.

I was afraid of that. Would trying to import file "manually" (through console) work? Any suggestions on how to try other import methods to figure out what's going on?

Thanks a bunch.

Member Avatar for smantscheff

Use the console mysql client. It will tell you where it fails.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.