Migrate from ESVA to EFA
Posted: 05 Mar 2014 22:56
Here's a basic howto to migrate from ESVA to EFA.
1) Export users and lists from ESVA.
SSH into your ESVA installation as root and run the following (without <>):
2) Transfer these sql files to your EFA system using WinSCP or similar
3) Backup your mailscanner on EFA, just in case
Look in /etc/EFA-Config for the root mysql password and copy it for the next commands
3) Import users and lists into EFA as root
Stop mailscanner
4) Start MailScanner
Log in and check your work. Note that you will need to log in with the admin that originally existed in your ESVA installation.
1) Export users and lists from ESVA.
SSH into your ESVA installation as root and run the following (without <>):
Code: Select all
mysqldump -u<yourmysqluser> -p<yourmysqlpassword> mailscanner users > /root/users.sql
Code: Select all
mysqldump -u<yourmysqluser> -p<yourmysqlpassword> mailscanner userfilters > /root/userfilters.sql
Code: Select all
mysqldump -u<yourmysqluser> -p<yourmysqlpassword> mailscanner whitelist >/root/whitelist.sql
Code: Select all
mysqldump -u<yourmysqluser> -p<yourmysqlpassword> mailscanner blacklist >/root/blacklist.sql
3) Backup your mailscanner on EFA, just in case
Look in /etc/EFA-Config for the root mysql password and copy it for the next commands
Code: Select all
sudo mysqldump -uroot -p<yourmysqlpassword> mailscanner > /root/mybackup.sql
Stop mailscanner
Code: Select all
sudo service MailScanner stop
Code: Select all
sudo mysql -uroot -p<yourmysqlpassword> mailscanner < /path/to/users.sql
Code: Select all
sudo mysql -uroot -p<yourmysqlpassword> mailscanner < /path/to/userfilters.sql
Code: Select all
sudo mysql -uroot -p<yourmysqlpassword> mailscanner < /path/to/whitelist.sql
Code: Select all
sudo mysql -uroot -p<yourmysqlpassword> mailscanner < /path/to/blacklist.sql
4) Start MailScanner
Code: Select all
sudo service MailScanner start