Forum Moderators: coopster

Message Too Old, No Replies

dbm file to mysql

is a converter/script available?

         

hakre

11:08 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



hi folks, i need some help on this issue. i got a .dbm database file (maybe from a perl script) and need to convert it into a mysql table or tables. is there a script available for this? anyone did it before? even to other formats (ie simple csv-file) might be usefull.

any help, comments or tips appreciated.

jatar_k

11:21 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



these may come in handy for getting the info and sorting it or creating a csv file

Database (dbm-style) abstraction layer functions [php.net]

hakre

11:29 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



hi jatar_k, thanks for your quick reply. that was the first step i did already, but dbm functions seem to be missing on my local windos system. i even can't figure out wich extension .dll is missing. google can't lead me to anything usefull. it's really crazy. never had such research probs at all.

jatar_k

11:39 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I guess you already tried this

By using the --enable-dba=shared configuration option you can build a dynamic loadable modul to enable PHP for basic support of dbm-style databases. You also have to add support for at least one of the following handlers by specifying the --with-XXXX configure switch to your PHP configure line.

andreasfriedrich

11:39 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Why donīt you use Perl [perl.com]? It ships with support for most dbm-style databases. If you are missing a module CPAN [perldoc.com] is your friend.

Andreas

hakre

11:43 pm on Mar 5, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



lo guys, thanks for the postings.

jatar_k: yes i read it. and if the people at the documentation would write one word more to tell me, which .dll i've to include on a win32 system, i would love them even more ;)

andreas: nice idea, but my last perl script i've written is some years old. i already found a lot of stuff related to dbm and perl but i don't want to run into it to setup perl etc. pp. at first. maybe i need, but this might be another race then.

i now try by enabling all extensions of php. maybe this works.

hakre

1:45 am on Mar 6, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



i now got some more details. the dbm file is a

MLDBM - store multi-level hash structure in single level tied hash

in short a mldbm one.

i don't get the key, wether this is supported by php or not. so perl seems to be the right choice.