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.