NDOUtils mysql question?

[Andrew Davis]

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

  A. Davis
  Email:     nccomp at gmail.com

  "There is no limit to what a man can accomplish
   if he doesn't care who gets the credit." - Ronald Reagan



shadih rahman wrote:
> I would double check these information.  Cacti runs on rrd( round 
> robin database).  I have innodb for my ndoutils 1.47b.
>
> On Fri, Aug 7, 2009 at 3:03 PM, Andrew Davis <nccomp at gmail.com 
> <mailto:nccomp at gmail.com>> 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. 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:     nccomp at gmail.com <mailto:nccomp at 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 at lists.sourceforge.net
>     <mailto: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
>
>
>
>
> -- 
> Cordially,
> Shadhin Rahman
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090807/973a1046/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
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
-------------- next part --------------
_______________________________________________
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