If optimistic, just copy the mnesia spool directory

mfoss — Thu, 28 May 2009 19:09:39 +0000

I am not sure because I didn't try, but maybe there could be a problem if one system is 32bit and the other 64bit. Other problem could be that the erlang node name of each ejabberd is different. Anyway, I propose you to be optimistic and expect that you will not have any of those problems.

So, being optimistic, the steps can be:

Stop both ejabberd, in old machine and in new machine.
Copy the files of mnesia spool directory from the old machine. The files are: acl.DCD, ... *.DCD, *.DCL, *.DAT. Copy them to the new machine, overwritting similar files that you will have almost empty.
Start the new ejabberd. If all went correctly, the rosters, offline messages, vcard, ... will be available in the new machine.

Other way to copy the information in the database would be to dump it to a binary file using the ejabberd WebAdmin or ejabberdctl; and then load the file in the new machine.

If your database is small (less than a few hundreds of users users), you can alternatively dump to a text file. That allows you to view the content of the database, and even modify it before loading in the new machine.

ejabberd - Comments for "Questions: Migrating from version 2.0.2_2 hosted on Windows to version 2.0.3_1 on Ubuntu?"

If optimistic, just copy the mnesia spool directory