Moving database to another server

[johnyu2012]

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.

[jimimaseye]

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.]

[mattg]

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

[johnyu2012]

Does the built in backup have limitation?

[mattg]

Depends on the version of hMailserver in use

What is the size of your data directory?

[MAiN_PRoToCoL]

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