Movim database clean up

Movim database clean-up

When your Movim database is corrupt or you changed XMPP server. Or you want to start over with the same instance. You need to clean-up the database. Proceed like this.

Empty all tables

Truncate each table

TRUNCATE TABLE `table`

for all Movim tables:

cache caps conference config contact item message postn presence privacy rosterlink sessionx subscription tag

Erase table config

DROP TABLE `config`

Re-create tables

Execute

php mud.php db set.

It will re-create the config table.

The admin account is reset to admin/password.