Transferring email responder rules
The transfer is performed only in the console and while logged in as the root user.
For MySQL and MariaDB
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
For SQLite3
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