Moving to new server- Windows Server 2019

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
Perica13
New user
New user
Posts: 2
Joined: 2019-11-09 14:12

Moving to new server- Windows Server 2019

Post by Perica13 » 2019-11-09 18:16

Hi to everyone,

i have a very old mail server and it's time to move on. My old server is an Windows Server 2008 with hMailServer 5.3.2-B1769 & MySQL 4.1.18 and i would like to move to Window Server 2019 .

So.. I can't backup the data within the HMailServer because of the 1,5Gb limit....my data folder is over 5Gb. On my new server I can only install the latest version of MySQL (8.0). Between my version of MySQL 4.1.18 and 8.0 are lightyears...guess I can't just copy some directorys.

I'm thinking of upgrading my HMS first...

What is the best way to proceed with the migration

Thanks in advance.

User avatar
ras07
Normal user
Normal user
Posts: 227
Joined: 2010-03-11 08:51

Re: Moving to new server- Windows Server 2019

Post by ras07 » 2019-11-09 21:54

Perica13 wrote:
2019-11-09 18:16
i have a very old mail server and it's time to move on. My old server is an Windows Server 2008 with hMailServer 5.3.2-B1769 & MySQL 4.1.18 and i would like to move to Window Server 2019 .

So.. I can't backup the data within the HMailServer because of the 1,5Gb limit....my data folder is over 5Gb. On my new server I can only install the latest version of MySQL (8.0). Between my version of MySQL 4.1.18 and 8.0 are lightyears...guess I can't just copy some directorys.

I'm thinking of upgrading my HMS first...

What is the best way to proceed with the migration
I would fully upgrade your existing system before migrating to the new machine. Your existing hMS version is nearly 10 years old (!) and there have been many updates (including some significant security updates to OpenSSL), but as far as I'm aware, you should be able to upgrade to the newest hMS directly, with no intermediate steps. I think I would upgrade hMS first and then upgrade MySQL, although I'm not positive on that point. In any case, MAKE SURE EVERYTHING IS VERY WELL BACKED UP FIRST. If possible, back up several ways (hMS backup, whole disk backup, and if you can virtualize the entire machine, back that up too).

Note that the 1.5 Gb backup limit is not applicable in later versions of hMS.

User avatar
ras07
Normal user
Normal user
Posts: 227
Joined: 2010-03-11 08:51

Re: Moving to new server- Windows Server 2019

Post by ras07 » 2019-11-09 22:26

Also make sure you understand the ins and outs of the various versions of MySQL. Note that you need the 32-bit libraries for the 32-bit version of hMailServer, even if you are running on a 64-bit OS. Also, there are issues with MySQL 8 - search the forums (use Google with the site:www.hmailserver.com qualifier, since the forum search tool doesn't want to search on "MySQL" since it returns too many matches).

TL;DR: consider sticking with the latest MySQL 5.x version, or moving to MariaDB (see https://www.hmailserver.com/forum/viewtopic.php?t=32869 for Dravion's very helpful MariaDB install guide).

User avatar
mattg
Moderator
Moderator
Posts: 20538
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Moving to new server- Windows Server 2019

Post by mattg » 2019-11-10 02:00

I would go latest 5.3.x Then latest 5.4.x then most recent Beta on the old box
(There was some significant changes in 5.4)

You should then be able to use the internal backup, selecting all options including compression

Install the same version of then new machine, setting up a new database as you go.
(The builtin database since 5.4 is a toy at best) You could use MySQL, MariaDB, MS SQL Server, or PostGreSQL

Most of us use either MariaDB or MySQL. As Ras07 says say if you use MySQL you will likely need the 32 bit version of the libmysql.dll - you could even copy this from your existing install

Copy the compressed backup to the new machine and restore
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 8295
Joined: 2011-09-08 17:48

Re: Moving to new server- Windows Server 2019

Post by jimimaseye » 2019-11-10 11:25

After upgrading you may want to give this a check. https://www.hmailserver.com/forum/viewt ... 21&t=28914
5.7 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

Perica13
New user
New user
Posts: 2
Joined: 2019-11-09 14:12

Re: Moving to new server- Windows Server 2019

Post by Perica13 » 2019-11-13 12:40

Hi guys,
did manage the migration to Windows Server 2019...thanks all for your help.
I did the upgrade & backup on the old machine. On the new machine i installed MySql 5.7.28 & HMS 5.6.7-B2425 and restored the compressed backup file. After restoring there was also no issue with the absolute datapaths. While installing MySql I needed just to copy the 32 bit version of the libmysql.dll...and everthing works(at the moment) :D
Next time hopefully i wont be waiting for 10 years to upgrade my system :wink:

Post Reply