[Resolved] need help with LOAD DATA INFILE

[jacksonpt]

I'm trying to convert an MS Access DB to MySQL. I exported the Access db to a txt file, with fields delimited by the '~' character. I put the txt file in the bin directory, and ran the following code from the command line:

C:\MySQL\bin>LOAD DATA INFILE 'scholarships.txt' INTO TABLE scholarships FIELDS TERMINATED BY '~'

I did a search on the boards and read that this is a good way covert DBs. It seems fairly simple and straight forward, but I can't get this command to work. I also tried a few other variations of this code, but they all resulted in the following error:

'LOAD' is not recognized as an internal or external command, operable program of batch file.

I don't know what that error is telling me, so I'm not sure what to do to correct it. Any help is appreciated.

[Shrike]

You'd need to have a MySQL command line open to run that command.

[jacksonpt]

I'm not sure I understand... as opposed to a DOS command line?

[Shrike]

Yep run the mysqld program or whatever it's called

[Shrike]

mysql.exe on windows

[jacksonpt]

great, thanks... I've got the command executed, but it's only reading in the first line of the text file. Each record is stored on its own line in the text file, so I thought I might need to add

LINES TERMINATED BY '\n'

to the command I posted above, but still no luck. Any ideas?

[jacksonpt]

nevermind... I got it.