Copying Graph Templates

[brgtt]

Hello folks,

I am kind of new on Cacti so I apologize if this is a silly question. I have already searched on this forum for the answer of my question below but I couldn't find anything.

I have two servers running Cacti. When I run "add_graphs.php --list-graph-templates" on the old one I have 208 templates and on the new one I have 34.

How do I copy all the templates from the old one to the new one?

Thanks for your help!

[vicmac]

Hello folks,

I am kind of new on Cacti so I apologize if this is a silly question. I have already searched on this forum for the answer of my question below but I couldn't find anything.

I have two servers running Cacti. When I run "add_graphs.php --list-graph-templates" on the old one I have 208 templates and on the new one I have 34.

How do I copy all the templates from the old one to the new one?

Thanks for your help!

Have you tried Console -> Export templates? The other option is trying to access mysql and see if you can do something from there.

[brgtt]

Have you tried Console -> Export templates? The other option is trying to access mysql and see if you can do something from there.

Hi vicmac,

Thanks for answering my question.

I would need to do this 200 times. I wonder if its possible to do this through command line or something like that.

Regards,

[brgtt]

Can someone please tell me what are the tables that I have to copy to have all the configuration (graph,data,host-templates snmp-queries everything) form the old server?

Regards,

+---------------------------------------+
| Tables_in_cacti |
+---------------------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| plugin_aggregate_color_template_items |
| plugin_aggregate_color_templates |
| plugin_config |
| plugin_db_changes |
| plugin_flowview_devices |
| plugin_flowview_dnscache |
| plugin_flowview_ports |
| plugin_flowview_queries |
| plugin_flowview_schedules |
| plugin_hooks |
| plugin_realms |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| superlinks_auth |
| superlinks_pages |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
+---------------------------------------+