DBF and MySQL fields

[dragancesu]

It is not difficult to make a program that works with MySQL data

but the first step is to transfer data from DBF to MySQL, in MySQL there are probably all types, but not all, so the problem is how to transfer.
DBF has a LOGICAL field that MySQL does not have, TINYINT is a substitute
DBF has a MEMO field, and MySQL has several types that can replace it, which variant are you using, VARCHAR or TEXT or BLOB or something else?

[serge_girard]

DBF memo is terrible! I use VARCHAR for pure text and BLOB for files etc.

Serge

[dragancesu]

Thank you Serge

Program in attachment create program for import, from dbf to mysql

1. build imp_gen
choice dbf and look imp<DBF>.prg

2. look line 12: PRIVATE cHostName:="localhost", cUserName:="prenos", cPassWord:="prenos", cDataBase:="prenos"
set your host, username, password and database

3. build imp<DBF>.prg

Note: if you are looking at this then I suppose you have basic knowledge of working with MySQL database

[serge_girard]

Thanks Dragan!