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 |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!








