IceWarp Server migration (Windows to 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 so you know you have a full backup.

Migration steps:

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

2. During migration, you can use the same license on your production server for up to 30 days in parallel. On the new server, activate your license using the remote console - Help - License - Activate License... - insert Order ID from the old server.

3. 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 

4. When you successfully migrate everything and have servers on the same version, to upgrade to the latest IceWarp version, you should always install several versions before getting to the latest. (for example, if you are running on v11 and older, first install v11.4.6, then v12.2, followed by v13.0 and 13.0.3.10 to finally land on v14.x)

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

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

(File system for accounts was removed in version 14, following steps are only relevant for version 13 or older.)

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 ***

Stop all IceWarp services before doing 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 DBs: accounts, antispam, antispam-reports, and groupware. The rest of the databases: directory cache, webclient, and EAS, are caches, and it's unnecessary 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 the remote console - Help - License - Activate License... - insert Order ID from the old server.

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