Moving data MySQL & filePro

[Richard Hane]

GCC Consulting <gccconsulting at comcast.net> wrote:    


________________________________

From:
filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On Behalf Of Richard Hane
Sent: Monday, September 11, 2006 4:17 PM
To: user list
Cc: Rick Hane
Subject: Moving data MySQL & filePro


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. 

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

Question...
What would the best way to get the data to fp? 
Can we generate a file from MySQL either in Excel format or fixed
length fields?
Can the data be written from the Lynix to one of my Windows
machines?
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?

Any help will be appreciated as this one has me stumped.

Thank you in advance,
Rick Hane
Controller
DeLuxe Stitcher Company
www.deluxestitcher.com

If you are running filePro ODBC, why not use it to link to your mySQL dbs
and then post this data to new filePro files? This would allow you to break
the connection to MySQL.

Richard Kreiss
GCC Consulting

  Richard,
   
  The problem is I can not see the MySQL db from my Windows servers.  I think as Walt and others have said my best bet will be to write a php script to create an Excel spreadsheet from the MySQL data then import the data in to fp.
   
  Thanks
  Rick Hane
   
   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060912/6b293ab2/attachment.html