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