changing of db
changing of db
hi,
i need to change my db type from compact to mysql (using dbsetup). however, i need to do a backup first of all my domain including their messages.
please let me know what external tool should i use to backup everything. the built-in backup asking to use some external tool if the size if more than 1gb.
thanks,
i need to change my db type from compact to mysql (using dbsetup). however, i need to do a backup first of all my domain including their messages.
please let me know what external tool should i use to backup everything. the built-in backup asking to use some external tool if the size if more than 1gb.
thanks,
- jimimaseye
- Moderator
- Posts: 8917
- Joined: 2011-09-08 17:48
Re: changing of db
Upgrade hmailserver to the latest version.v The limit of 1gb on the internal backup has been raised to 16gb so you may then be able to do it.
Upgrade to latest
Internal Backup with ALL OPTIONS ticked
Db setup creating external db
Restore from backup
Upgrade to latest
Internal Backup with ALL OPTIONS ticked
Db setup creating external db
Restore from backup
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: changing of db
hi,
My email size is more than 16gb... is it possible to do a back-up of the settings, then manually copy the hmailserver/data then change dbsetup, restore the settings then paste the old data folder to the new data folder?
My email size is more than 16gb... is it possible to do a back-up of the settings, then manually copy the hmailserver/data then change dbsetup, restore the settings then paste the old data folder to the new data folder?
- jimimaseye
- Moderator
- Posts: 8917
- Joined: 2011-09-08 17:48
Re: changing of db
Im afraid you fell in to the trap of using internal database for non-permitted commercial use. (You shouldnt have been doing it as it's against the EULA, and the internal database has restrictions and one of them is the lack of 'administration' of it preventing you from doing administration and what you want to do - not good for a commercial environment).
The only thing you can do with that method is import the email messages with Data Directory Synchroniser (DDS) but then they will appear in the INBOX of each account. That means all email messages - sent, subfolders, the lot, will all be imported and appear in the INBOX. You will then have to drag out and re-drop the relevant emails back to the iriginal folders they came from (sent, sub folders etc).
So, if you wish to go with that and accept it, the process would be:
1, backup DOMAINS and SETTINGS with internal backup
2, dbsetup pointing to external DB (MySQL is my recommendation)
3, do restore from DOMAIN/SETTINGS backup
4, check/ensure data directory is pointing to the data directory which hgolds all the .EMLS
5, Run DDS (this will populate the inbox of each account with ALL emails belonging to that account).
6, review each account and drag and drop the relevant emails to their intended folders out of the Inbox.
The only thing you can do with that method is import the email messages with Data Directory Synchroniser (DDS) but then they will appear in the INBOX of each account. That means all email messages - sent, subfolders, the lot, will all be imported and appear in the INBOX. You will then have to drag out and re-drop the relevant emails back to the iriginal folders they came from (sent, sub folders etc).
So, if you wish to go with that and accept it, the process would be:
1, backup DOMAINS and SETTINGS with internal backup
2, dbsetup pointing to external DB (MySQL is my recommendation)
3, do restore from DOMAIN/SETTINGS backup
4, check/ensure data directory is pointing to the data directory which hgolds all the .EMLS
5, Run DDS (this will populate the inbox of each account with ALL emails belonging to that account).
6, review each account and drag and drop the relevant emails to their intended folders out of the Inbox.
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: changing of db
if i do the DDS, it will re-populate all the user inboxes. this means, once the user open their email clients, all emails will be downloaded even those that has already been downloaded ?
- jimimaseye
- Moderator
- Posts: 8917
- Joined: 2011-09-08 17:48
Re: changing of db
Yes.
Are you saying that clients connect via POP3? And if so are they leaving emails on the server? or do they connect via IMAP?
Are you saying that clients connect via POP3? And if so are they leaving emails on the server? or do they connect via IMAP?
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: changing of db
hi,
some are using pop and some using imap.
some are using pop and some using imap.
Re: changing of db
if i can get the size reduced to 16gb, i can just do a normal backup of domain / settings and email, am right?
- jimimaseye
- Moderator
- Posts: 8917
- Joined: 2011-09-08 17:48
Re: changing of db
In theory, yes. (You will need the recent version of HMS).
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: changing of db
Rather than change to MySQL, use the Microsoft SQL installer to upgrade to a better MS SQL database.janrev15 wrote:hi,
My email size is more than 16gb... is it possible to do a back-up of the settings, then manually copy the hmailserver/data then change dbsetup, restore the settings then paste the old data folder to the new data folder?
MS SQL Express is zero cost and you should be able to upgrade a MS SQL CE to a MS SQL Express fairly easily.
just stop hmailsevrer then run the MS SQL installer and select upgrade option, find the MSSQL CE instance and upgrade, then restart hMailsevrer when done
Make sure that you do some sort of backup first, and if possible trial upgrade on another machine. I think copying the entire hmailserver directory (including the database and data directory) to a new machine on same path, then installing hmailserver again over the top should make it functional on a new machine
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
Re: changing of db
yes, planning to install hmail into a spare pc, restore the settings then copy / paste the whole directory. hopefully it works.
the reason i want to mysql is because i want to have access on phpwebadmin.
the reason i want to mysql is because i want to have access on phpwebadmin.
Re: changing of db
That is available no matter the database.janrev15 wrote:the reason i want to mysql is because i want to have access on phpwebadmin.
The requirements for PHPWebAdmin is a webserver + PHP on the same machine as hMailserevr
Mind if you are using the MS SQL CE with 15 GB of mail, you should change that as the CE database is toy at best, and will let you down sooner rather than later
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
Re: changing of db
so even if i used the built in db, phpwebadmin should still work?
i was able to access phpwebadmin just now, but i am not able to login error : Cannot log in to the MySQL server.
can you point me to the correct guide on this?
i was able to access phpwebadmin just now, but i am not able to login error : Cannot log in to the MySQL server.
can you point me to the correct guide on this?
Re: changing of db
Are you sure it is the hmailserver PHPWebAdmin that you are trying to log into not some other tool like PHPMyAdmin which is a MySQL administration tool?
You copied the PHPWebAdmin folder from your hMailserver installation to your webserver
You copied the PHPWebAdmin folder from your hMailserver installation to your webserver
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
Re: changing of db
Mattg are you saying that I can upgrade the database that came with HMS to MS SQL Express?mattg wrote:Rather than change to MySQL, use the Microsoft SQL installer to upgrade to a better MS SQL database.janrev15 wrote:hi,
My email size is more than 16gb... is it possible to do a back-up of the settings, then manually copy the hmailserver/data then change dbsetup, restore the settings then paste the old data folder to the new data folder?
MS SQL Express is zero cost and you should be able to upgrade a MS SQL CE to a MS SQL Express fairly easily.
just stop hmailsevrer then run the MS SQL installer and select upgrade option, find the MSSQL CE instance and upgrade, then restart hMailsevrer when done
Make sure that you do some sort of backup first, and if possible trial upgrade on another machine. I think copying the entire hmailserver directory (including the database and data directory) to a new machine on same path, then installing hmailserver again over the top should make it functional on a new machine
Theoretically, what about happen to all the emails?
Re: changing of db
hi guys,
i was able to successfully configure my phpwebadmin.
temporarily, I will be keeping the current db setup. I will be asking all user to clear their old mails and once the total messages is less than 16gb, i'm going to upgrade the db.
thanks for all the help guys..
i was able to successfully configure my phpwebadmin.
temporarily, I will be keeping the current db setup. I will be asking all user to clear their old mails and once the total messages is less than 16gb, i'm going to upgrade the db.
thanks for all the help guys..
Re: changing of db
Exactly what I am sayingMarHMS wrote:Mattg are you saying that I can upgrade the database that came with HMS to MS SQL Express?
Theoretically, what about happen to all the emails?
All mail and settings should not be affected
PLEASE TEST on a spare server if you can, and remember to BACKUP the entire hMailserver installation first
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
Re: changing of db
GREAT!mattg wrote:Exactly what I am sayingMarHMS wrote:Mattg are you saying that I can upgrade the database that came with HMS to MS SQL Express?
Theoretically, what about happen to all the emails?
All mail and settings should not be affected
PLEASE TEST on a spare server if you can, and remember to BACKUP the entire hMailserver installation first
Our mail server is a VM, so I'll back-up that
Re: changing of db
Also, other than a back-up of the VM, or Windows Server Backup, is there another backup that you would suggest for the entire HMS installation?mattg wrote:Exactly what I am sayingMarHMS wrote:Mattg are you saying that I can upgrade the database that came with HMS to MS SQL Express?
Theoretically, what about happen to all the emails?
All mail and settings should not be affected
PLEASE TEST on a spare server if you can, and remember to BACKUP the entire hMailserver installation first
Re: changing of db
viewtopic.php?f=7&t=28025&p=174106&hili ... pt#p174124
viewtopic.php?f=9&t=30217#p188995
There are many ways, here is a couple of examples
viewtopic.php?f=9&t=30217#p188995
There are many ways, here is a couple of examples
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
Re: changing of db
Thanks a lot!mattg wrote:viewtopic.php?f=7&t=28025&p=174106&hili ... pt#p174124
viewtopic.php?f=9&t=30217#p188995
There are many ways, here is a couple of examples
- jimimaseye
- Moderator
- Posts: 8917
- Joined: 2011-09-08 17:48
Re: changing of db
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: changing of db
Wow, seems like the perfect script.jimimaseye wrote:viewtopic.php?f=21&t=28139
Re: changing of db
There is also the possibilty to decrypt the mssql-ce HMS Setup generated password with your hMailServer Administrator Password and login via a free MS-SQL-CE Workbenchtool like CE-Query.
You need to execute the vbscript decryptpassword.vbs inside your hMailServer installation and type in your hMailServer Administrator password to get the password you need for CE-Query. Good luck.
You need to execute the vbscript decryptpassword.vbs inside your hMailServer installation and type in your hMailServer Administrator password to get the password you need for CE-Query. Good luck.