Troubles with replication my zabbix server to another

[fsousa]

Hello,

I want to copy my entire Zabbix configuration (templates, groups, users, permissions, history, etc) from one Zabbix server to another.

A bit more detail: We have one production Zabbix server which the database seems to be growing too quick. We will try partitioning the tables but we want to do this first in environment test. So we need to replicate the production zabbix server to test zabbix server.

Here the things we have tried, but without success:

• dump my database and then recover to empty database (DB schema created): ibd files didn't appear
• rsync my zabbix in /var/lib/mysql/ to my other server: when I tried to select any table I get "Empty set"

Any suggestion?

Thank you.

[fsousa]

Hi alamin,

What did you mean with

then download local folder and then upload another folder into root directory

?

Thank you.

[fsousa]

Hello,

I found the solution for my problem, I've to enable the innodb_file_per_table.

Enable innodb_file_per_table vi /etc/my.cnf

[mysqld]
innodb_file_per_table = 1

Apparently when I imported the dump the ibd files per table aren't created.

Thank you.