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" <Tom@Jesusforme.com>
> > > To: <plug-discuss@lists.PLUG.phoenix.az.us>
> > > 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
>
(text/plain)