NDOUtils mysql question?

[Marc Powell]

On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote:

> 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.

It's not a database level option. It's table level.

> 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...

My Google-fu seems to be more powerful.

mysql -u Username -p -h database.hostname.com -e "show table status"  
databasename.

--
Marc


------------------------------------------------------------------------------
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 at 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