MySQL - Is the release distributed with WAMP ok?

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
brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-10 18:31

Hi,

I want to change from the CE-version to rhe "normal" MySQL. Hoping to get better performance with my thousands of mails.
I already have WAMP installed on this computer. Is the with WAMP installed MySQL (5.6.17) suitable for this?

What do you think:

- The already installed release is OK
- Update WAMP to an actual release
- Install MySQL additional, because the WAMP-MySQL is not the proper one

regards/brutzler

User avatar
Dravion
Senior user
Senior user
Posts: 1466
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: MySQL - Is the release distributed with WAMP ok?

Post by Dravion » 2019-10-10 19:30

No Problem.

Only the MySQL Service name is called something else as in a normal MySQL Installation.

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-10 23:21

Hi,
and HELP!!!

- made a backup of settings
- changed to WAMP-MySQL-Database.
- restarted hmailserver
- made a restore of settings
- restarted hmailserver

settings look good, but client doesnt see any mails in the folders?


What went wrong?

palinka
Senior user
Senior user
Posts: 1191
Joined: 2017-09-12 17:57

Re: MySQL - Is the release distributed with WAMP ok?

Post by palinka » 2019-10-10 23:30

Did you import all the tables from the old db? Or only the settings?

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-10 23:35

I only imported the settings.
How to import the old tables? I did not see any backup possibility for it.
(I changed from MySQL-CE to MySQL...)

Now I started the "DataDirectorySnchronizer.exe"
Hope this was no mistake, but hmailserver told me success. And the client sees mails again. If all is ok I can not check in short time.

But still missing the public folders....


And looks like the mails from the public folders went into Inbox of the mailaccount????
OMG... Lost the whole structure of the public folder :-(

palinka
Senior user
Senior user
Posts: 1191
Joined: 2017-09-12 17:57

Re: MySQL - Is the release distributed with WAMP ok?

Post by palinka » 2019-10-10 23:49

You'll be missing all the folders because they're stored in your old database.

Sorry, i don't know anything about the ce version, but you somehow need to export them in an sql format readable by mysql. Then import that into mysql. If you want to try that, i would suggest the following:

First, export the old hmailserver database.
Then import into mysql in a different database name and make sure everything is working with mysql.
Then reinstall hmailserver and choose the new mysql database instead of the default one you created with the regular backup. This will contain all your messages, folders, etc..
Then run the dds to pick up mail received since you quit using the ce version.

The problem with the dds is that it imports all mail to the inbox so all folders are missing, sent mail is mixed with inbox mail, etc.. So even though this is kind of a pain, your users will thank you for it.

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-10 23:55

puuuhhhhh....

>> First, export the old hmailserver database.
The question is how... a.s.o....

Can I go back to the internal (mySQL-CE) database?
Using the hMailserver Database Setup, I do not see any choice for this....

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

Re: MySQL - Is the release distributed with WAMP ok?

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

The thing I think that you are missing is that the CE is the MS SQL, not MySQL

MS SQL CE = Microsoft SQL Server Compact Edition

You need to use hmailserver's internal backup and restore,

Need to back up everything including messages and MUST use compression.
ALL OPTIONS MUST BE SELECTED
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-11 00:12

oh...my mistake.
Sure: MS SQL-CE

Oh I am a stupid idiot: I saw the option messages, but didnt activate it....

Now again the master question:
How can I tell hmailserver, to use again the internal MS-SQL-CE database-structure? Then i can make a valid backup.

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

Re: MySQL - Is the release distributed with WAMP ok?

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

change the ini file (use a copy of the old one if you have it) then restart the hmailserver service

(copy the new one first just to be safe)
For the CE there is no password stored, just the name of the database, and it uses Windows Authentication
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-11 00:34

Oh you are my hero.

Good idea!
Sure I have a copy. And its good to use admin rights for stop and start service :-)

Now I see the folders again in hmailserverAdmin-GUI. And can make a "full" backup

Edit:
out of the log:

Code: Select all

The size of the data directory exceeds the maximum RECOMMENDED size for the built in backup (1.5GB). Please consult the backup documentation
Can this be a problem?

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

Re: MySQL - Is the release distributed with WAMP ok?

Post by mattg » 2019-10-11 01:05

Depends on the version of hMailserver, but that is a warning only for recent versions. It has been taken out of ALPHA versions, so won't be there at all soon.

Once we could only backup up to the 1.5 GB, then it moved to 15 GB, but for a while there has been no functional limit
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

brutzler
Normal user
Normal user
Posts: 47
Joined: 2018-11-21 23:37

Re: MySQL - Is the release distributed with WAMP ok?

Post by brutzler » 2019-10-11 01:27

Finished backup and restore.
looks good!

Thx for all

Post Reply