Unknown database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Orkan
Forum Commoner
Posts: 32
Joined: Sun Aug 24, 2003 9:07 am
Location: Ukraine
Contact:

Unknown database

Post by Orkan »

Need help...

I have some database... all I know is all I can see... There are *.db, *.px, *.xg0, *.yg0 files. I need to import this into MySQL..
Who has any ideas bout how can I progress with this problem???

ThanXXX
mikeb
Forum Commoner
Posts: 60
Joined: Tue Jul 08, 2003 4:37 pm
Location: Dublin, Ireland

Post by mikeb »

These files are database and index files for Paradox (A database system) which is currently owned by Corel. The Paradox system comes with Corel's 'Office' program available from their site. I think they have a trial ownload which might help you get some useful output from your files? You could dump the data to CSV and import into SQL perhaps? I'm a newbie at php so I'm not sure if there's a direct driver for Paradox files. There are people with much better knowledge on the forum who might be able to help you further. If not, that might put you in the right direction. Here's a direct link to the Office suite:

http://www.corel.com/servlet/Satellite? ... 2153063297

cheers,

Mike
User avatar
Orkan
Forum Commoner
Posts: 32
Joined: Sun Aug 24, 2003 9:07 am
Location: Ukraine
Contact:

Post by Orkan »

Thanx for reply...

But problem is that client has this Paradox databases, and wants to import it periodically onto the web-site. So I don't need a prog that can read this databases... I need to WRITE the own one on PHP so that it can work on *nix & Win systems... So, I need a description of files structure so that I can manipulate this files by myself. Does any one can help me?
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

You can insert/fetch data from a Paradox db using ODBC. I think that is available for both *nix and Windows enviroments. But if so, you need to configure your server(s) to work with that solution.

Not familiar with ODBC to much, so I'm no help. But browser the Paradox website and Google for more info.
User avatar
Orkan
Forum Commoner
Posts: 32
Joined: Sun Aug 24, 2003 9:07 am
Location: Ukraine
Contact:

unfortunately...

Post by Orkan »

Thanx for advice...
But I can't do this through ODBC cause my server has no ODBC support and I personally can't do this cause hoster don't permit... :(
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

Oh, ouch...
If anyone else has no idea (someone might know of a class that can convert it), I think your stuck (?).

If you can get your client to send the data as cvs files instead of the Paradox ones, you might be able to handle it.

Best of luck.
Post Reply