Unable to restore 20gig database backup to newly installed zabbix

[ptera]

Yes I needed to upgrade my old mariadb to the new version before I could import it - but alas - it still failed even after doing that. argh!

[Markku]

Ok you lost me now. Which MariaDB versions do you have in the old server and in the new server? In which way have you installed them? (From sources, from Ubuntu repo, from MariaDB repo)

Is the old zabbix+database still working normally?

Markku

[ptera]

Original server on which zabbix is running with no hick ups is suspected of being compromised, Centos 7.7, zabbix 3.4.15, Mariadb 5.5.64
The last new server attempt was Ubuntu 18.4, zabbix 3.4.15, Mariadb 10.1.x installed from the install disk.

I am running the zabbix server on vm so I made a backup of the virtual it, restored it to a different vm server with a different IP address, shutdown zabbix
and then upgraded the MariaDB from 5.5.64 to 10.0 and then 10.1.

Then I backed up the database. Copied over to the new machine and restored the backup. Still failed.
So now I am trying to install mariadb 5.5.64 and zabbix 3.4.15 to the new machine and try the backup restore again.

[ptera]

Well that was a failure - when I tried to install zabbix it tried to install maridb 10.1 and messed everything up.

[Markku]

With apt you can do this to prevent installing database with zabbix-server-mysql:

# apt install zabbix-server-mysql mariadb-server-10.1-
...
The following NEW packages will be installed:
  zabbix-server-mysql

Note the minus in the end of mariadb-server-10.1

Markku

[ptera]

Cool Thanks