[ejabberd] Question about dumping mnesia databases, importing to PostgreSQL
allie at internalreflection.net
Sun Sep 21 11:20:52 MSD 2008
On Sep 21, 2008, at 1:35 AM, Allie wrote:
> Hi all, new ejabberd user here and I'm a tad confused. When I
> initially set up my server, I didn't realize the odbc parameters I
> set did not automatically apply to all the other modules that could
> use it, and didn't realize that rosters and such are handled by
> different modules. So, I'm trying to figure out how to dump the
> databases and try to get them imported into PostgreSQL so I can
> point the modules at the database.
> Anyway, the help and documentation for ejabberdctl says,
> "ejabberdctl dump file" to dump a database to a text file. What
> exactly does this mean? Is "file" the resulting text file name?
> Is that a word that's part of the command? No matter what
> combination I use, I can't seem to find any output files in any of
> the ejabberd directories. It also doesn't give me any sort of
> error. What am I doing wrong? Is there any easy way to get the
> mnesia data into PostgreSQL?
> I'm running ejabberd 2.0.2 on FreeBSD 6.2, using PostgreSQL 8.2.7
> for the back-end. I *think* erlang's version is r12b4 (installed
> from FreeBSD ports), and I've compiled in the pgsql module from
> svn. Thank you for any help or information you can provide. :)
Replying to my own message. :) I think I figured it out using
ejd2odbc.erl. But, I'm still learning. I'll send another message to
the list if I have any more questions.
More information about the ejabberd