Moving data MySQL & filePro

[Walter Vaughan]

Richard Hane wrote:

> Situation....
> Our network is a 5 server Windows 2000 & 2003. One of those servers is a 
> Lynix server.  One of our old apps is written on the Lynix in MySQL with 
> a Wiki front end display. I would like to move the data to our filePro 
> ODBC 1.0.13D09.


The old app is a LAMP stack?

Wiki? Which wiki? There is a 99% change it's written with php or perl.
Regardless there is a 100% chance it won't work with filepro live. Most likely 
it has a series 3.xx.xx mysql database.

> BTW... I am not familar with MySQL and only sightly more familar with Lynix.

Well its about time you did. 1994 was 12 years ago.

What's the end game here? Your users want the information that is in your wiki 
screens to be co-mingled with what you have in filepro?

> What would the best way to get the data to fp?
Literally there is probably a 1000 ways. No soup for you until you google it and 
get stuck with code.

> Can we generate a file from MySQL either in Excel format or fixed length 
> fields?
Yes.

> Can the data be written from the Lynix to one of my Windows machines?
Yes.

> I believe MySQl is available for Windows too.  Would that be the best 
> was; install the Windows vesion and some how move the data between the 2 
> MySQL dbs?

No.  Well no you do a data dump and move that, not the actual storage files. So 
yes you can move it to mysql. You'll export the data, not the directory files.