Our Nagios server also has Cacti on it. I'm pretty sure that Cacti uses
an InnoDB database, while NDOUtils uses myISAM. The two are backed up
differently (example: mysqlhotcopy doesn't working on InnoDB databases).
Does anyone know what mysql command you run to determine which type of
DB is used for various databases, especially considering you can run
multiple types at once? I know I can use "mysqlshow" or the "show
databases;" options to show the databases themselves, but it doesn't
list the DB type. Using mysqlshow with a -t and a DB name shows the
table types, but again, not the database types. I'm sort of stuck on
this. I want to make sure I know what DB types I'm dealing with so I can
ensure I'm backing them up properly. Google searches aren't helping...
the results all go back to the "mysql versus innodb" debate...
--
A. Davis
Email: ncc...@gmail.com
"There is no limit to what a man can accomplish
if he doesn't care who gets the credit." - Ronald Reagan
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
