Server migration (Windows -> Windows)

Migration guide

To migrate you first must make sure you have a backup of everything, the mail, the groupware database, etc. To be safe backup the entire /Icewarp folder just so you know you have a full backup.

Migration steps:

1. Install the same version of IW on both servers.

2. Copy over the following folders from the old to the new server:
Mail (must be copied with a tool which will save timestamps - robocopy)
Spam (if using the default anti-spam database)
Calendar (if using the default groupware database)
Config 

3. During migration you cannot have the same license on both servers. On the new server activate a trial license which you can purchase: https://shop.icewarp.com/purchase/get_trial.php

After doing this you will be running the same settings, users, domains, etc. on the new server.

*** If using a file system for accounts ***

On the old server go to the console and highlight all the domains and then right-click and choose "Export accounts to a file" and save this.

Take this file to the new server and right-click in the console and choose "Import accounts from a file". This will restore all the users and domains. 

*** For the creation of DB in MySQL on the new server ***

(create collation based on the location, more - https://mariadb.com/kb/en/supported-character-sets-and-collations/):

CREATE DATABASE accounts default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE antispam default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE groupware default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE webclient default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE eas default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE dircache default charset utf8mb4 collate utf8mb4_unicode_ci;
CREATE DATABASE asreports default charset utf8mb4 collate utf8mb4_unicode_ci;

*** If using the MySQL databases do a DUMP of DB ***

1. Go to the CMD and navigate to MySQL/MariaDB bin folder
2. For export of DB do: mysqldump -hDB_HOST -uDB_USER -pDB_PASSWORD --opt --quote-names --skip-set-charset --default-character-set=utf8mb4 --single-transaction EXAMPLEOFDB > C:\exmpleofdb.sql
3. This will create DUMP in root (C:\) location
4. For import DUMP of DB to the new server do the following: mysql -hDB_HOST -uDB_USER -pDB_PASSWORD --default-character-set=utf8mb4 exampleofdb < C:\exampleofdb.sql

You can migrate only these DB's: accounts, antispam, antispam-reports, groupware. The rest of the databases: directory cache, webclient, and EAS are caches and it's not necessary to migrate them.

After the import of DUMP switches the following value in the API console:
system.mysqldefaultcharset utf8mb4

*** After migration ***

After migration stop all services on the old server and activate your license on the new server using remote console - Help - License - Activate License... - insert Order ID from the old server

If you didn't migrate directorycache then start a refresh of dir cache for the whole server in System - Advanced - Directory Cache