HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

This section contains user-submitted tutorials.
Post Reply
User avatar
jimimaseye
Moderator
Moderator
Posts: 8175
Joined: 2011-09-08 17:48

HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by jimimaseye » 2016-04-30 12:31

The attached Word documents "HMS_Install_Recovery_Manual_.doc" (zipped for forum) is a simple guide from me to a basic install of Hmailserver with MySQL external database. It also covers the RESTORE of emails and settings from previous internal backup. Note that there are 2 versions of the document: one for v5.5 and one for more recent v5.7 of MySQL (due to the installation GUI of MySQL being fundamentally different).

This procedure is useful for migrating Hmailserver from server to server or changing the database type (recommended if initially using the default internal database.)

Note: In the event of a migration/Data Restore (following this manual), if the internal backup is not usable (due to size limits), then further help can be found: viewtopic.php?f=21&t=28017

HMS_Install_Recovery_Manual_57.zip
Basic walkthrough guide to Install of Hmailserver 32bit with MySQL v5.7. 18 February 2017.
(792.34 KiB) Downloaded 791 times
HMS_Install_Recovery_Manual.zip
Basic walkthrough guide to Install of Hmailserver 32bit with MySQL v5.5. Updated 16 May 2016.
(392.6 KiB) Downloaded 475 times

The following ZIP is the 32bit "libmysql.dll" required for installing against the 32bit Hmailserver. (Details within the document).
32bit LIBmySQL_dll.zip
libmysql.dll 32bit 5.7.17 (taken from MySQL - updated 11/12/18)
(1.28 MiB) Downloaded 376 times
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 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

User avatar
fjansen04
Normal user
Normal user
Posts: 31
Joined: 2008-08-30 15:49
Location: The Netherlands

Re: HOW TO: Simple guide to installing Hmailserver with MYSQL plus Data Restore

Post by fjansen04 » 2016-05-01 12:03

Very useful, thank you!
HMS 5.6.8 B2431 on Windows Server 2016 Essentials

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

Re: HOW TO: Simple guide to installing Hmailserver with MYSQL plus Data Restore

Post by jimimaseye » 2016-05-01 12:13

Thanks Fred.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 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

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

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by jimimaseye » 2017-02-18 19:08

Added version of manual for more recent MySQL version 5.7 (due to GUI installation process differences).
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 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

Homegrownandy
New user
New user
Posts: 11
Joined: 2019-11-01 15:53

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by Homegrownandy » 2019-11-05 16:08

Hello,

Ive been trying all day to get 1.7 to work for me.
1.7 Modify the ‘datadir=’ entry to reflect your chosen location.
# Path to the database root
datadir= D:\Datastore\MySQLdatafiles
Ive created the Datadir folder.. When I change the .ini file to reflect this change I can never get SWL server to connect again. Do i need to move the data folder manually?

Andy.

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

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by jimimaseye » 2019-11-05 20:47

V1.7 of what? And what is " I can never get SWL server "?

[Entered by mobile. Excuse my spelling.]
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 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

Homegrownandy
New user
New user
Posts: 11
Joined: 2019-11-01 15:53

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by Homegrownandy » 2019-11-06 13:59

Homegrownandy wrote:
2019-11-05 16:08
Hello,

Ive been trying all day to get 1.7 to work for me.
1.7 Modify the ‘datadir=’ entry to reflect your chosen location.
# Path to the database root
datadir= D:\Datastore\MySQLdatafiles
Ive created the Datadir folder.. When I change the .ini file to reflect this change I can never get SWL server to connect again. Do i need to move the data folder manually?

Andy.
I pasted 1.7 from your guide in my post for reference. and SQL not SWL sorry mistake. Basically when I change the INI file SQL server stops and will not reconnect. Clearly im missing something.. Ill have another go

Homegrownandy
New user
New user
Posts: 11
Joined: 2019-11-01 15:53

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by Homegrownandy » 2019-11-06 14:08

In 1.8 you say "the restart should not create/relocate all the data files to the new directory". Is this correct?

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

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by mattg » 2019-11-07 02:51

What are you trying to move the database or the data directory?

What database do you use?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Homegrownandy
New user
New user
Posts: 11
Joined: 2019-11-01 15:53

Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore

Post by Homegrownandy » 2019-11-11 17:43

I would have updated earlier but I forgot my password and wasnt recieving the reset email. I'm only testing at the moment so dont worry about it. I left the database/data all as default. I assume this wont be a problem and moving it is 'nice to have'. Correct me if im wrong and its a necessity.

Thank you.

Post Reply