I have an mnesia database dump from an ejabberd server (DCD, DCL, and DAT files), and I'm trying to recover any data I can from this database. It would be ideal to convert it to some kind of SQL database, however I would settle for a simple text dump (from there I could probably rebuild the database).
I'm an erlang/mnesia newbie, but here is what I managed to do from the online docs:
bash$> erl -mnesia dir '"ejabberd_dump_dir"'
stopped db nodes = [ejabberd_dump_dir]
remote = [ list of the tables from ejabberd_dump_dir ]
bash$> ejabberdctl --auth admin ejabberd passwd restore ejabberd /home/user/ejabberddmpdir/
bash$> ejabberdctl --auth admin ejabberd passwd export2odbc ejabberd /home/user/mnesiatosql/
I'm still working out the details as to how the whole mnesia node system works, but I ended up using this to load the database into mnesia:
bash$> erl -name ejabberd@localhost -mnesia dir '"/home/usr/ejabberd@localhost/"'
Thanks to anyone who took a look.