<BR><BR><B><I>GCC Consulting <gccconsulting@comcast.net></I></B> wrote: <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <div><BR><BR><BR>________________________________<BR><BR>From:<BR>filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com<BR>[mailto:filepro-list-bounces+gccconsulting=comcast.net@lists.celestial.com]<BR>On Behalf Of Richard Hane<BR>Sent: Monday, September 11, 2006 4:17 PM<BR>To: user list<BR>Cc: Rick Hane<BR>Subject: Moving data MySQL & filePro<BR><BR><BR>Situation....<BR>Our network is a 5 server Windows 2000 & 2003. One of those servers<BR>is a Lynix server. One of our old apps is written on the Lynix in MySQL<BR>with a Wiki front end display. I would like to move the data to our filePro<BR>ODBC 1.0.13D09. <BR><BR>BTW... I am not familar with MySQL and only sightly more familar<BR>with Lynix.<BR><BR>Question...<BR>What would the best way to get the data to fp? <BR>Can we
generate a file from MySQL either in Excel format or fixed<BR>length fields?<BR>Can the data be written from the Lynix to one of my Windows<BR>machines?<BR>I believe MySQl is available for Windows too. Would that be the<BR>best was; install the Windows vesion and some how move the data between the<BR>2 MySQL dbs?<BR><BR>Any help will be appreciated as this one has me stumped.<BR><BR>Thank you in advance,<BR>Rick Hane<BR>Controller<BR>DeLuxe Stitcher Company<BR>www.deluxestitcher.com<BR><BR>If you are running filePro ODBC, why not use it to link to your mySQL dbs<BR>and then post this data to new filePro files? This would allow you to break<BR>the connection to MySQL.<BR><BR>Richard Kreiss<BR>GCC Consulting<BR></div> <div>Richard,</div> <div> </div> <div>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.</div> <div> </div> <div>Thanks</div> <div>Rick Hane</div> <div> </div> <div> </div></BLOCKQUOTE>