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: ncc...@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 <ncc...@gmail.com
<mailto:ncc...@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: ncc...@gmail.com <mailto:ncc...@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@lists.sourceforge.net
<mailto: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
--
Cordially,
Shadhin Rahman
------------------------------------------------------------------------------
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