Transferring email responder rules

Please note!

The transfer is performed only in the console and while logged in as the root user.

Connect via SSH to the source server and export the email_responder table from the ispmgr database:

mysqdump ispmgr email_responder > /PATH-TO-DUMP/TABLE_DUMP.sql

Connect via SSH to the destination server and lock the panel to import data correctly:

/usr/local/mgr5/sbin/mgrctl -m ispmgr -l

Transfer the previously created dump to the destination server and perform the import:

mysqdump ispmgr email_responder < /PATH-TO-DUMP/TABLE_DUMP.sql

Finally, clear the database cache and restart the panel:

/usr/local/mgr5/var/.db.cache.* -f && rm /usr/local/mgr5/var/.xmlcache/* -rf && /usr/local/mgr5/sbin/mgrctl -m ispmgr -u

Connect via SSH to the source server and install SQLite3 if it was not installed earlier:

apt install sqlite3

Next, export the email_responder table from the ispmgr database by running the following commands:

sqlite3 /usr/local/mgr5/etc/ispmgr.db
.output /PATH-TO-DUMP/TABLE_DUMP.sql
.dump email_responder
.exit

Connect via SSH to the destination server and install SQLite3 if it was not installed earlier:

apt install sqlite3

Lock the panel to import data correctly:

/usr/local/mgr5/sbin/mgrctl -m ispmgr -l

Next, move the dump you created earlier to the destination server and perform the import:

sqlite3 /usr/local/mgr5/etc/ispmgr.db
.import /PATH-TO-DUMP/TABLE_DUMP.sql email_responder
.exit

Finally, clear the database cache and restart the panel:

/usr/local/mgr5/var/.db.cache.* -f && rm /usr/local/mgr5/var/.xmlcache/* -rf && /usr/local/mgr5/sbin/mgrctl -m ispmgr -u