Moving database to another server

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
johnyu2012
Normal user
Normal user
Posts: 135
Joined: 2012-09-11 06:33

Moving database to another server

Post by johnyu2012 » 2022-07-02 08:26

I want to create a backup email server. I tried to do a sqldump to make a sql file backup then use that to import to the backup server. When I use the mysql client on the command prompt to import, it only import some tables not all. Does anymore have this problem? I make sure to run as administrator already.

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

Re: Moving database to another server

Post by jimimaseye » 2022-07-02 08:47

You might be interested in this.

(Depending on your level of expertise you may just read utt and pick up some tips specifically from '4th')

https://www.hmailserver.com/forum/viewt ... 21&t=28139

The recovery command from the backup is

Code: Select all

mysql -u root -p"yourpassword" < "D:\backuptemp\hmaildata\MYSQLDump_2021-05-24-200000.mysql
I know it works - I've used it many times.

[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

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

Re: Moving database to another server

Post by mattg » 2022-07-02 10:31

I'd also look at using the built-in backup and restore built into the GUI

Remember that the messages are NOT stored in the database, the database only contains the data about the messages
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

johnyu2012
Normal user
Normal user
Posts: 135
Joined: 2012-09-11 06:33

Re: Moving database to another server

Post by johnyu2012 » 2022-07-02 12:03

Does the built in backup have limitation?

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

Re: Moving database to another server

Post by mattg » 2022-07-02 23:06

Depends on the version of hMailserver in use

What is the size of your data directory?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

MAiN_PRoToCoL
New user
New user
Posts: 18
Joined: 2022-07-19 05:31

Re: Moving database to another server

Post by MAiN_PRoToCoL » 2022-07-19 06:12

Host it in the cloud. For databases, Amazon Relational Database Service has automatic Backups/snapshots and standby replica.

Post Reply