<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000099"> Really? You sure about that? I'm pretty confident that mysql supports different types of databases (myISAM and InnoDB as two of them) as well as different table types within a database. Your reply did help, though, as when I ran it for the default mysql DB, I was reminded of the phrase "engine" in the output. Thus, now I see: mysql -u root -p -e "show table status" mysql Enter password: +---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------------------------------------------------+ | columns_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 227994731135631359 | 1024 | 0 | NULL | 2009-02-12 10:21:04 | 2009-02-12 10:21:04 | NULL | utf8_bin | NULL | | Column privileges mysql> show engines; +------------+---------+----------------------------------------------------------------+ | Engine | Support | Comment | +------------+---------+----------------------------------------------------------------+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | | BerkeleyDB | YES | Supports transactions and page-level locking | | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | | EXAMPLE | NO | Example storage engine | | ARCHIVE | NO | Archive storage engine | | CSV | NO | CSV storage engine | | ndbcluster | NO | Clustered, fault-tolerant, memory-based tables | | FEDERATED | NO | Federated MySQL storage engine | | MRG_MYISAM | YES | Collection of identical MyISAM tables | | ISAM | NO | Obsolete storage engine | +------------+---------+----------------------------------------------------------------+ 12 rows in set (0.00 sec) An "engine" is another way of saying "database type". This is distinct from a table type. Of course, the above only shows me the engines that are already compiled in and available for use, but hopefully I can go forward from here... I'm thinking I can do a "show databases;", then pump that into a "for x in ..." to show the engine type for each DB. Thanks for the assist... <pre class="moz-signature" cols="72"> A. Davis Email: <a class="moz-txt-link-abbreviated" href="mailto:nccomp@gmail.com">nccomp@gmail.com</a> "There is no limit to what a man can accomplish if he doesn't care who gets the credit." - Ronald Reagan </pre> Marc Powell wrote: <blockquote cite="mid:12E7E781-8002-416A-8D65-EB6B49C739D7@ena.com" type="cite"> <pre wrap="">On Aug 7, 2009, at 2:03 PM, Andrew Davis wrote: </pre> <blockquote type="cite"> <pre wrap="">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. </pre> </blockquote> <pre wrap=""> It's not a database level option. It's table level. </pre> <blockquote type="cite"> <pre wrap="">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... </pre> </blockquote> <pre wrap=""> 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. <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/bobj-july">http://p.sf.net/sfu/bobj-july</a> _______________________________________________ Nagios-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </pre> </blockquote> </body> </html>