History and trends data gone after import

[lbjensen]

Hi

I have just partitioned my history and trends tables, and because there are very large, I have
Stopped the zabbix server
renamed the tables in mysql
create the history and trends tables with partitions
started zabbix server again
Exported the data from history and trends tables with mysqldump
imported the data to the history and trends tables with mysql -uzabbix -p zabbixdb < history.sql

The partitions are working and the data is imported again, but I cannot see the data in the graphs for any items now


Do I have to do anything to get the data view able again in Zabbix?

Cheers
Lars
Denmark

[ingus.vilnis]

Hi Lars,

Do you have the data in the tables if doing a direct SQL query? What is the oldest timestamp you get?

 
 [FONT=arial]SELECT FROM_UNIXTIME(MIN(clock)) FROM `history_uint`;[/FONT]

You mentioned renaming of tables. Any chance you have now some tables with incorrect names?