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