ejabberd - Comments for "Is there easy way to edit user JID and other settings?" https://www.ejabberd.im/node/4150 en ncpnc wrote: some JID's https://www.ejabberd.im/node/4150#comment-56355 <div class="quote-msg"> <div class="quote-author"><em>ncpnc</em> wrote:</div> <p>some JID's should be changed and also some users@domain1 will become users@domain2</p> <p>Simple reedit JID or domain on both client and server side would be optimal solution.</p> <p>my server uses default mnesia database.</p></div> <p>If you have few registered accounts (a few hundreds or less), you can try this:</p> <ol> <li>In WebAdmin -&gt; Nodes -&gt; your node -&gt; database backup -&gt; create a plain text dump of mnesia </li><li>Edit that file with a powerful text editor (Microsoft Nodepad isn't), and make the changes you want, like replacing domain1 with domain2, or delete {...} elements, or write new {...} elements. </li><li>Stop ejabberd. </li><li>Copy the Mnesia database spool files (see <noindex><a href="http://www.process-one.net/en/ejabberd/guide_en#install" title="http://www.process-one.net/en/ejabberd/guide_en#install" rel="nofollow" >http://www.process-one.net/en/ejabberd/guide_en#install</a></noindex> ) to a safe location, and delete the files. </li><li>Start ejabberd. It will have an empty database: no users registered. </li><li>Create the account that you typically used to enter WebAdmin. </li><li>Now you can enter WebAdmin again. Verify that there is only 1 registered user (you). </li><li>Go to the database page again, and restore the modified plain text file. </li><li>Now you should see all the users, with their modified rosters. </li></ol> <p>Alternatively to WebAdmin, the database can be backup and restored using the ejabberdctl script.</p> Thu, 08 Jul 2010 10:24:26 +0000 mfoss comment 56355 at https://www.ejabberd.im