[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