KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

Search found 3 matches
KS-Soft Forum Index
Author Message
  Topic: MYSQL Logging with Stored Procedure
chickenwing

Replies: 2
Views: 14441

PostForum: Library   Posted: Thu Jun 18, 2009 3:15 am   Subject: MYSQL Logging with Stored Procedure
For information i am using this at the moment for logging every test and also for midnight logging with the backup log option.
  Topic: MYSQL Logging with Stored Procedure
chickenwing

Replies: 2
Views: 14441

PostForum: Library   Posted: Thu Jun 18, 2009 3:13 am   Subject: MYSQL Logging with Stored Procedure
so now here comes the view

DROP VIEW IF EXISTS `hostmonitor`.`hostmon_complete`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hostmonitor`.`hostmon_complete` AS select ...
  Topic: MYSQL Logging with Stored Procedure
chickenwing

Replies: 2
Views: 14441

PostForum: Library   Posted: Wed Jun 17, 2009 11:43 pm   Subject: MYSQL Logging with Stored Procedure
At the first i will post all the tables that i have created:

DROP TABLE IF EXISTS `hostmonitor`.`agent`;
CREATE TABLE `hostmonitor`.`agent` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
...
 
Page 1 of 1
All times are GMT - 6 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index