#这种方法会出现 监控项不可用的情况
1.停掉zabbix_server
2.重重名表
RENAME TABLE history to history_20180117;
RENAME TABLE history_uint to history_uint_20180117;
RENAME TABLE history_str to history_str_20180117;
RENAME TABLE history_text to history_text_20180117;
RENAME TABLE trends to trends_20180117;
RENAME TABLE trends_uint to trends_uint_20180117;
RENAME TABLE events to events_20180117;
3.重新创建这几张表
show create table history;
再创建表
3. 启动zabbix_server
4. 删除重命名表