HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
- jimimaseye
- Moderator
- Posts: 10060
- Joined: 2011-09-08 17:48
HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
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
The following ZIP is the 32bit "libmysql.dll" required for installing against the 32bit Hmailserver. (Details within the document).
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
The following ZIP is the 32bit "libmysql.dll" required for installing against the 32bit Hmailserver. (Details within the document).
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
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829
Re: HOW TO: Simple guide to installing Hmailserver with MYSQL plus Data Restore
Very useful, thank you!
HMS 5.6.9-B2587.46 on Windows Server 2019
- jimimaseye
- Moderator
- Posts: 10060
- Joined: 2011-09-08 17:48
Re: HOW TO: Simple guide to installing Hmailserver with MYSQL plus Data Restore
Thanks Fred.
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
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829
- jimimaseye
- Moderator
- Posts: 10060
- Joined: 2011-09-08 17:48
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
Added version of manual for more recent MySQL version 5.7 (due to GUI installation process differences).
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
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829
-
- New user
- Posts: 11
- Joined: 2019-11-01 15:53
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
Hello,
Ive been trying all day to get 1.7 to work for me.
Andy.
Ive been trying all day to get 1.7 to work for me.
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?1.7 Modify the ‘datadir=’ entry to reflect your chosen location.
# Path to the database root
datadir= D:\Datastore\MySQLdatafiles
Andy.
- jimimaseye
- Moderator
- Posts: 10060
- Joined: 2011-09-08 17:48
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
V1.7 of what? And what is " I can never get SWL server "?
[Entered by mobile. Excuse my spelling.]
[Entered by mobile. Excuse my spelling.]
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
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829
-
- New user
- Posts: 11
- Joined: 2019-11-01 15:53
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
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 goHomegrownandy wrote: ↑2019-11-05 16:08Hello,
Ive been trying all day to get 1.7 to work for me.
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?1.7 Modify the ‘datadir=’ entry to reflect your chosen location.
# Path to the database root
datadir= D:\Datastore\MySQLdatafiles
Andy.
-
- New user
- Posts: 11
- Joined: 2019-11-01 15:53
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
In 1.8 you say "the restart should not create/relocate all the data files to the new directory". Is this correct?
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
What are you trying to move the database or the data directory?
What database do you use?
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
https://www.hmailserver.com/documentation
-
- New user
- Posts: 11
- Joined: 2019-11-01 15:53
Re: HOW TO: Simple guide to installing Hmailserver with MySQL plus Data Restore
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.
Thank you.