I would do this but its a propriatry piece of software running on NT its the MLS real estate listings its just a simple client that does quieries for us. There is no way to export or dump the database. alls i know is that it is in .dbf format i have the table and the fields. the versions of dbf2mysql all fail with SQL statement errors i think its a flaw in the program cuz i dont see any errors in the create table statement at all. Regards Nigel Sollars On Tue, 23 Oct 2001, Gorman, John wrote: > Perhaps I am being to simplistic, but most databases have a load/unload > process. > > i.e. UNLOAD TO 'table.uld' SELECT * FROM mytable > > Why not just unload from the one database and load into the other? > > John > > -----Original Message----- > From: Nigel Sollars [mailto:xknight@shellyeah.org] > Sent: Tuesday, October 23, 2001 10:53 AM > To: Phoenix Lug > Subject: Re: dbf2mysql info please > > > > I have tried both 1.10e and 1.14 bot fail to convert the dbf's i have. > if i could get it to work that would be awesome or maybe someone could > help me write a perl script to do the job? a challenge perhaps hehe.. > > Since i dont get my books for another week or so any help would be cool. > .... > > Would someone like to give me a hand getting this one sorted? > > any help on this would be fantastic ... > > Tom could u give me all the info u have on the dbf format? > > if you could again that would be great, ... > > > Regards > Nigel Sollars. > > > > On Mon, 22 Oct 2001, Kevin Brown wrote: > > > also it's a project on sourceforge now. > > > > http://dbf2mysql.sourceforge.net/ > > > > Nancy Sollars wrote: > > > > > > ----- Original Message ----- > > > From: "Tom Achtenberg" > > > To: > > > Sent: Monday, October 22, 2001 5:46 PM > > > Subject: RE: dbf2mysql info please > > > > > > > Considering I work in FoxPro all day, I'd be interested in this too. > What > > > > is the "contributed program"? And where can I download it? > > > > > > I got it from ftp.mirror.ac.uk once in cd to sites from there then > > > ftp.mysql.com > > > > > > you will see the dir Contribs in there u will find > dbf2mysql-1.1.14.tar.gz > > > > > > thats the name of the file dbf2mysql. > > > > > > Regards > > > > > > Nigel > > > > > > > > -----Original Message----- > > > > From: plug-discuss-admin@lists.PLUG.phoenix.az.us > > > > [mailto:plug-discuss-admin@lists.PLUG.phoenix.az.us]On Behalf Of Nigel > > > > Sollars > > > > Sent: Monday, October 22, 2001 3:57 PM > > > > To: Phoenix Lug > > > > Cc: Bristol Lug > > > > Subject: dbf2mysql info please > > > > > > > > > > > > > > > > Hi, > > > > > > > > Has anyone had any experience with the contributed program that > converts > > > > .dbf ( Fox Pro etc etc ) Database Files to Mysql tables? > > > > > > > > if so could u please give an example of complete syntax for this > program. > > > > > > > > The readme is a little ambiguous to say the least. > > > > > > > > > > > > Regards > > > > > > > > Nigel Sollars > > > > > > > > ________________________________________________ > > > > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail > doesn't > > > post > > > > to the list quickly and you use Netscape to write mail. > > > > > > > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > > > ________________________________________________ > > > > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail > doesn't > > > post to the list quickly and you use Netscape to write mail. > > > > > > > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > > > > > > > ________________________________________________ > > > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't > post to the list quickly and you use Netscape to write mail. > > > > > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > ________________________________________________ > > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't > post to the list quickly and you use Netscape to write mail. > > > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > > > > ________________________________________________ > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post > to the list quickly and you use Netscape to write mail. > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > ________________________________________________ > See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail. > > PLUG-discuss mailing list - PLUG-discuss@lists.PLUG.phoenix.az.us > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss >