Migrate from Mnesia to MySQL?

Hello, it's me again with a new problem/question.

Is it somehow possible to migrate an existing ejabberd database from Mnesia (internal) to MySQL? With everything possible (currently: auth, roster, vcard, offline, last - did I forget something?) Well, at least userdata, vcards and roster should be kept...

I tried the following steps(with V 1.1.1):
1. backed up database, changed the config to support MySQL, restored DB
Result: works, but existing users are kept in mnesia, everything new goes to MySQL

2. stopped ejabberd, deleted the spool directory, started ejabberd
Result: Error

Errormessage (with command-line):
kane ~ # ejabberdctl ejabberd@kane restore /home/ejabberd/testback1
Can't restore backup from "/home/ejabberd/testback1" at node ejabberd@kane: Table passwd does not exist.
{"init terminating in do_boot",{undef,[{ejabberd_ctl,start,[]},{init,start_it,1},{init,start_em,1}]}}

Crash dump was written to: erl_crash.dump
init terminating in do_boot ()

3. stopped ejabberd, emptied database (while keeping its structure) because of content from Step1, restored backup
Result: Error (same as above)

Am I missing something or doing something wrong?

And, if it's not possible at the moment, is it planned to implent this in the future?

Greetz
Jan

Re: Migrate from Mnesia to MySQL?

Well, it seems that such a possibility doesn't exist (yet). Is it planned in the future?

Yes, it will be done, but we

Yes, it will be done, but we did not yet plan it.

--
Mickaël Rémond
Process-one

Re: Yes, it will be done, but we

mremond wrote:

Yes, it will be done, but we did not yet plan it.

Wasn't it possible with the mnesia2odbc script?

We did not test it yet. It

We did not test it yet. It might be possible already or require a small change.

--
Mickaël Rémond
Process-one

Syndicate content