<!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"> Okay, perhaps I inverted it then. My build of Cacti stores everything to a mysql DB, though it could admittedly be a myISAM DB with NDOutils being of the InnoDB type. However it works out, I'm pretty confident that I have two database types on one mysql server and I'm trying to figure out how to use a mysql command to list the database names and their types... # mysql -u root -p -e "show databases;" Enter password: +--------------------+ | Database | +--------------------+ | information_schema | | cacti | | mysql | | nagdb | | nagios | | test | +--------------------+ <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> shadih rahman wrote: <blockquote cite="mid:6db4a4200908071252u115e80fci4994ac48f7e0f916@mail.gmail.com" type="cite">I would double check these information. Cacti runs on rrd( round robin database). I have innodb for my ndoutils 1.47b. <div class="gmail_quote">On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis <<a moz-do-not-send="true" href="mailto:nccomp@gmail.com">nccomp@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div bgcolor="#ffffff" text="#000099">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... <pre cols="72">-- A. Davis Email: <a moz-do-not-send="true" href="mailto:nccomp@gmail.com" target="_blank">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> </div> ------------------------------------------------------------------------------ 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 moz-do-not-send="true" href="http://p.sf.net/sfu/bobj-july" target="_blank">http://p.sf.net/sfu/bobj-july</a> _______________________________________________ Nagios-users mailing list <a moz-do-not-send="true" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a moz-do-not-send="true" href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">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 </blockquote> </div> -- Cordially, Shadhin Rahman </blockquote> </body> </html>