[SOLVED] lost table

[inle]

Hi
I'am using centreon 2 but I had an accident(a missconfiguration) and know my centstorage.log table is really broken.

can someone get connected to his mysql server and do:
>use centstorage;
> desc log;

and then post de result so I can recreate my table?

Thanks in advance.

ps: After this I will do mysqldump every week

[inle]

Hi
I'am using centreon 2 but I had an accident(a missconfiguration) and know my centstorage.log table is really broken.

can someone get connected to his mysql server and do:
>use centstorage;
> desc log;

and then post de result so I can recreate my table?

Thanks in advance.

ps: After this I will do mysqldump every week

Salut
je suis en train d'utiliser centreon 2 mais j'ai eu un problème (mauveuse configuration) et maintenant je ne peut pas récupérer ma table centstorage.log.

Quelqu'un peut me donner la structure de cette table comme ça je peut la recréer?

Merci d'avance.

[AkHeNaToN]

CREATE TABLE IF NOT EXISTS `log` (
`log_id` int(11) NOT NULL auto_increment,
`ctime` int(11) default NULL,
`host_name` varchar(255) default NULL,
`service_description` varchar(255) default NULL,
`status` varchar(255) default NULL,
`output` text,
`notification_cmd` varchar(255) default NULL,
`notification_contact` varchar(255) default NULL,
`type` varchar(255) default NULL,
`retry` int(255) NOT NULL,
`msg_type` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL,
`instance` int(11) NOT NULL default '1',
PRIMARY KEY (`log_id`),
KEY `host_name` (`host_name`(64)),
KEY `service_description` (`service_description`(64)),
KEY `status` (`status`),
KEY `instance` (`instance`),
KEY `ctime` (`ctime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



pour Centreon 2.0.2

[inle]

Merci beaucoup AkHeNaToN
Tout est rentré dans l'ordre maintenant
Cord.....