I am attempting to create a link from a dbase (.dbf) database to a mysql database. Here's the description:
dbase file is a file that gets updated on a daily basis. Changes to this file can be a change in a record or the addition of a record. no record is 'deleted'. Updated/new records include a timestamp: | LTRDTE | timestamp(14) | LTRTIM | varchar(5) Now, the big issue is that the number of records kept in the dbase file is only about 67,000 (and growing each day), while the records in the MySQL table is about 256,000 and growing as the dbase grows. the MySQL is read-only (think of it as an archive). I'd like to be able to 'update' the information in mysql. So, that if there is a change to record # "12345" (example), only record 12345 would be replaced. I've tried to use the dbftomysql program (on windows), but, it seems to not like my data. It gives me errors when I attempt to run it. The .dbf file resides on a windows machine, but the mysql is on linux. Both systems talk to each other via. SMB (Samba). Hence, the .dbf is on a mounted filesystem on the linux box. So, the solution could be a program that would run on linux or on windows. Also, remember I need to be able to only change what's changed on the mysql side.. Not delete and re-create the entire table, etc.. A nice benefit would be to have the software automagically alter the table if new columns are created in the dbase file. Thanks in advance, David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
