Search found 3 matches

by chickenwing
Thu Jun 18, 2009 3:15 am
Forum: Library
Topic: MYSQL Logging with Stored Procedure
Replies: 2
Views: 39417

For information i am using this at the moment for logging every test and also for midnight logging with the backup log option.
by chickenwing
Thu Jun 18, 2009 3:13 am
Forum: Library
Topic: MYSQL Logging with Stored Procedure
Replies: 2
Views: 39417

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 `agent`.`Agent` AS `Agent`,`mastertest`.`mastertest` AS `mastertest`,`servicecomp`.`servicecomp` AS `se...
by chickenwing
Wed Jun 17, 2009 11:43 pm
Forum: Library
Topic: MYSQL Logging with Stored Procedure
Replies: 2
Views: 39417

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, `Agent` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_F...