European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


ALL :: ZONES :: export to DBF and MDX
By: PHP newbee	Date: 26/12/2002 00:00:00	Points: 100	Status: Answered Quality : Excellent
Hi All, We have to export some data from a MySQL DB to a DBase .dbf and a index .mdx. We are currently pulling the data via a php page, and using the built in dbase functions to generate the dbf file. The problem is, php does not support indexes! Is there any way to do this? Preferably, is there a way to do this via a command-line in linux? We need this to re-create the dbf and mdx every night. Thanks a bunch!
By: VGR	Date: 27/12/2002 06:11:00		Type : Answer
no no way indices are too (platform,RDBMS)-dependant ; each index has to be reconstructed. In your case, to minimize both the amount of data transferred and the number of times the target index is rebuilt, I would recommend transferring only new and deleted lines, and let the target DB (dBase) perform the index' adaptation based upon those "updates"

Do register to be able to answer

page generated in 61.752080 milliseconds