Horvath Gyula wrote:
>
> Dear Members!
>
> How can I convert a Corel-Paradox table (.db) to MySQL database ?
>
> Thanks!
>
> ---------------------------------------------------------------------
> 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
This may help. I found it in the archive.coreldevelopers.paradox-web
newsgroup on the cnews.corel.com news server. Another possibility is to
export it to Access and use the MyAccess addin to convert to MySQL
(assuming you have Access in the first place)
Subject:
Re: Paradox + MySQL + PHP
Date:
Wed, 17 Jan 2001 00:05:42 +0100
From:
"ais" <[EMAIL PROTECTED]>
Organization:
"Another Corel User"
Newsgroups:
archive.coreldevelopers.paradox-web
References:
1 , 2
OK,
Firstly I installed the MySQL admin script on the server and created my
database tables with it (I use 3 tables).
To get the data for upload I run a query on my offline Paradox database
(one
for each table) and directly from the query answer table (in Paradox) I
do a
"File Export" and save it to a .txt file.
The MySQL admin script has an "import" function, so I just select the
particular database table I want to update and do an import direct from
my
local hard drive.
This link is to a demo of the admin script that I use
http://gossamer-threads.com/perl/mysqlman/mysql.cgi
There are others but this one is free, very easy to install and has all
the
functionality I need.
There is another script that I have read about called PHPAdmin which I
have
not tried but I believe it is quite popular from what I have read.
Let me know if you need more info.
ais
Lance Leonard <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> ais,
>
> I'd be interesting in seeing some details on how you handle the data
> transfer itself, e.g. how you get the .txt into MySQL.
>
> -- Lance
>
> ais wrote:
> >
> > Hi,
> >
> > I have been posting my questions in this newsgroup to solve my database
> > problem, and now that I have, I feel it is contribution time. Sorry I
can't
> > pay back those who helped me directly, but hopefully this will help the
few
> > who use Paradox offline and a unix solution to host their database.
> >
> > I am using Paradox to maintain a database offline and was previously
using a
> > flat file database script (DBMan) to host/view it online.
> >
> > Because the database is set to outgrow DBMan, I had to come up with an
> > alternative.
> >
> > I have found the following to be an effective solution :
> > - Paradox to maintain the database offline.
> > - MySQL to host the database online
> > - PHP to view the data
> >
> > I am using MySQL & PHP mainly because it is bundled with my server.
> >
> > To transfer the data online I export the data from Paradox to a .txt
file
> > before importing it into MySQL.
> >
> > To create/maintain the MySQL tables and import the data text file, I use
a
> > free perl script of which there are several (I use the one from
> > gossamer-threads}. It makes MySQL administration an absolute no brainer.
> >
> > To view the data, there are also several free scripts but I decided to
write
> > my own and learned a bit of PHP in the process.
> >
> > For those interested you can see the database/php script in action at
> > http://embassylinks.com (use Cyprus as the Guest in Custom Data Search
as
> > all countries are not added yet).
> >
> > I am happy to share the little I know with anyone trying to do something
> > similar.
> >
> > ... and sorry if it a little off-topic as well - but it does let me keep
> > using Paradox and get it on the web.
> >
> > ais
---------------------------------------------------------------------
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
