Then I figured I could convert DBF files to CSV files first and then import them into MySQL using
LOAD DATA INFILE
, but the question was how to do the DBF-to-CSV part. OpenOffice Calc and MS Excel were out of the question (converting 30 tables every night manually wasn't something I was eager to do; besides, many of them exceed the limit of 65536 rows), so I had to look for other options, preferably something that can run unattended at night while I am at home sleeping.