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
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