"database is not a Zabbix database"

[akbar415]

I'm trying to migrate the zabbix database from mysql community to mysql enterprise and the follow error occurs

Table 'zabbix.users' doesn't exist [select userid from users limit 1]
  3571:20150629:174601.263 cannot use database "zabbix": database is not a Zabbix database

Somebody can help me please?

[Herwish]

Have you migrated your structure and data? If so - what tool have you used?

[LenR]

Was there much of a version change between the different mysql versions? Did you run mysql upgrade?
Are you using innodb file per table?

[akbar415]

Solved

Was there much of a version change between the different mysql versions? Did you run mysql upgrade?
Are you using innodb file per table?

The migration is from Mysql community version to enterprise version. I don't know what command was used. I'm not the DBA

Have you migrated your structure and data? If so - what tool have you used?

DBA has a tool to do that.

We figured out what's going on. The mysql tool show a finish status os the migration, but they don't really finished.

After a few hours work's fine.

Thanks!


BTW: In 3 months of use, the zabbix database has 14 G of data (WTF) with 75% infrastrucure being monitored. I see a future with a lot of tunning.

[LenR]

Run, don't walk, to database partitioning :-)

Use partitioning instead of housekeeping to manage history and trends retention.