ejabberd: inspect Mnesia tables?

Question

I'm digging into ejabberd but I can't find a way to inspect its Mnesia tables.

Is there something like the MySQL shell to inspect tables?

I've found ./ejabberdctl dump to dump the database contents into a file, but not an easy way to select data (through a shell for ex.) — Tommy, Jul 27 '10 at 13:23

score 11 · Accepted Answer · edited Apr 06 '12 at 03:23

11

You may use the Table Visualizer, in module tv.

It can help examine ets tables and mnesia tables. You can simply start it on any connected node (e.g. with "ejabberdctl debug"), with:

 tv:start().

edited Apr 06 '12 at 03:23

png

5,990
2
25
16

answered Jul 27 '10 at 13:22

tonio

10,355
2
46
60

score 2 · Answer 2 · answered Mar 04 '15 at 12:31

Just go to folder where ejabberd is installed.Then go to bin folder and type command ./ejabberdctl dump_table file_name_in_which_table_will_be_dumped Table_Name.

This file will be created in database/ejabberd@localhost/dump_table file_name_in_which_table_will_be_dumped

ejabberd: inspect Mnesia tables?

2 Answers2