[ejabberd] Recover data from archive_msg.DAT

Evgeny Khramtsov xramtsov at gmail.com
Wed Feb 7 09:01:32 MSK 2018

Tue, 6 Feb 2018 23:05:01 +0100
pitchum <pitchum at gramaton.org> wrote:

> Hi there,
> recently my ejabberd reached the limit of 2GB of storage for MAM data
> using the mnesia database. I know I should migrate to using an SQL
> backend and I tried this:
>     sudo -u ejabberd ejabberdctl --no-timeout export2sql \
>       gramaton.org /tmp/dump.sql
> But nothing happens and file /tmp/dump.sql is not generated.
> Did I do something wrong?
> Maybe I can write a script to parse that file by myself but I don't
> know how it is structured. Any hints appreciated.

If the table is unusable I think you cannot do anything, except
restoring it from backup and then convert to SQL.

More information about the ejabberd mailing list