Subject: mysqldump and LOCK TABLES?
Paul Beard <[email protected]> Sat, 24 Oct 2015 20:33:54 -0700
| Newsgroups | gmane.network.cacti.user |
|---|---|
| Message-ID | <[email protected]> |
Something seems bad wrong here. mysqldump -uroot -p cacti --skip-lock-tables LOCK TABLES `cdef_items` WRITE; /*!40000 ALTER TABLE `cdef_items` DISABLE KEYS */; /*!40000 ALTER TABLE `cdef_items` ENABLE KEYS */; UNLOCK TABLES; Error: Couldn't read status information for table colors () mysqldump: Couldn't execute 'show create table `colors`': Table 'cacti.colors' doesn't exist (1146) echo 'show tables' | mysql -uroot -p cacti 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_config plugin_db_changes 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 user_auth user_auth_perms user_auth_realm user_log version ------------------------------------------------------------------------------