dump progress db to mysql

[jumbosafari]

hi. I'm a complete newbie to progress.

specs:
progress 9.1c
mysql 5
linux redhat

i would like to dump a progress db to mysql, any ideas?
there is a problem, i don't have a login or password to the progress db however i do have the .b1 .d1 .db and .lg files.
can i use those in some way to convert them into csv files or mysql dump?

any help would be much appreciated.
thanks.

 

[TomBascom]

Is the Progress db running? Do you have some sort of license or just the files mentioned?

 

[jumbosafari]

i currently have the progress db 9.1c installed on a redhat machine.
however, i do not have root access to the machine nor do i have any credentials for the progress db.

on the positive side i have access to the files mentioned above (.b1 .d1 .lg .db .st and .lic)

i'm looking for a way to use those files to end up with a csv or sql dump.

is it possible to get into the progress db admin tool without login creds?

 

[jumbosafari]

as well i have access to all files of the entire linux filesystem.

 

[jumbosafari]

possibly this can achieved from the command line using a progress db command?

 

[TomBascom]

It depends...

First run "showcfg" (it is in $DLC/bin -- DLC is an environment variable that must point to the directory that Progress is installed in) this will tell us what sort of license you have. That helps to establish the range of possible solutions.

Next try to start a session. If the database is not being used by anyone then "$DLC/bin/pro databasename" will start a single user session. If it is in use then use "mpro" instead.

If this works (and it should) then you will either be prompted for a username/password (since you don't have one select "cancel" or type ^e) or you will be brought directly to "the editor" which is a screen with a strip menu across the top and some status information on the bottom.

Assuming that you have at least a "query/runtime" license type the following:

for each [b]tablename[/b] no-lock:
  display [b]tablename[/b].
end.

followed by ^x.

Unless unusual steps have been taken to lock down the target db you should see data for the chosen table. Type ^e to stop the display. Then type ^z to clear the program.

If that all worked type "dict", ^x, navigate to "admin", select "dump data" and then dump the tables that you wish to dump. (You will get space delimited quoted strings).

If it doesn't work the showcfg information will probably tell us why and there may be other ways to get what you need.

 

[jumbosafari]

thanks a million.
I'll give this a try first thing tomorrow and will let you know of the results.

 

[jumbosafari]

showcfg returned:

product name: workgroup db
user limit: 15
serial num: 003335765
control numbers: sffff-sdfds-sdfsf
version number: 9.1c
machine class: kb
port number: 38

 

[jumbosafari]

from now on i do have root access to the redhat linux installation

 

[jumbosafari]

result for :
$DLC/bin/pro databasename
--this version of progress requires a start up procedure.(495)

result for :
$DLC/bin/mpro databasename
--error. there is no server for database.(1423)

sometimes i also get another error.
--standard input and output are on different terminals. (360)

any ideas?