I’m need to migrate my Kopano System to a new Server. At this point it runs on a Backup DC. The current Domain doesn’t sync properly between the Master DC and the Backup DC. I will start with a freshly installed system. I have built up a new DC and installed Kopano core on it Added all needed users. This system works great.
Now I want to migrate the Kopano Data from the old system to the new one.
As of I have some difficulties on the DC. - This is not the topic here.
It seems to me that the easiest way to migrate the data by doing a SQL dump and coping all the needed data into the new Server.
I have created a dump file.
Copied the dump file and the database file from the old server to the new one. Imported the dump file and restarted mysql.
And it fails.
I end up with:
/var/lib/mysql# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Di 2018-02-27 17:37:04 CET; 17s ago
Process: 15905 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
Process: 15947 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Feb 27 17:37:04 tre-ucs-mail mysql: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Feb 27 17:37:04 tre-ucs-mail systemd: mysql.service: control process exited, code=exited status=1
Feb 27 17:37:04 tre-ucs-mail systemd: Failed to start LSB: Start and stop the mysql database server daemon.
Feb 27 17:37:04 tre-ucs-mail systemd: Unit mysql.service entered failed state.
I have no idea how I can resolve the issue.