MySQL import


#1

Is it possible to write a PHP code that will import DBF file in MySQL DB?
Every day I need to import about 50 dbf tables to DB using Navicat(annoying job)
All tables are imported in one table.


#2

You’re going to have to figure out what the internal structure is of this .dbf fiel (I’m not sure if this is a file created by MySQL), and you can unwrap/explode() it in PHP, loop through the data and INSERT it into MySQL that way. I’m not sure if you can import it directly into MySQL, bypassing the PHP part.


#3

This is a table created by Micr.Visual FoxPro.
Mysql have command LOAD DATA INFILE but only for txt file.


#4

I’m afraid a direct import is not gonna work then. So check out the internals of the .dbf file, and see if you can use PHP to get the relevant data extracted.