Gossamer Forum
Home : Products : Others : MySQLMan :

Import only gets 1 record

Quote Reply
Import only gets 1 record
I use Win95/Apache/ActiveState Perl and MySQL 3.23.
The Mysqlman seems to be a very handy tool. I set up my db (45 fields) with no problem. But when I went to import from my '|' delimited data file, it only imported the first record. I used:
################
Local Import
Do not show error message if there are duplicate records and do the following:Ignore

Fields:
Delimiter: |
Escape Character: \

Records:
Delimiter: \n
Ignore first 0 Lines
####################
Has anyone else had any import problems like this?

Regards,
Byron


Quote Reply
Re: Import only gets 1 record In reply to
Nope...using the DEFAULT values of the IMPORT option, I have had no problems. Try using the DEFAULT values of the IMPORT option and see what happens.

Regards,

Eliot Lee
Quote Reply
Re: Import only gets 1 record In reply to
Those are the default import settings...