• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

mysqlcheck: Got error: 2013: table module_watchdog_sys_stat

KlausZ

Basic Pleskian
Hello all,

ich have some troubles in 2 psa-tables.
One of them is DomainsTraffic, the other is module_watchdog_sys_stat.
I think in both are data who is not really high necessary, so i can drop the tables an make it new.
I found the structure for "DomainsTraffic":
CREATE TABLE `DomainsTraffic` (
`dom_id` int(10) unsigned NOT NULL,
`date` date NOT NULL,
`http_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`http_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`ftp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`smtp_out` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_in` bigint(20) unsigned NOT NULL DEFAULT '0',
`pop3_imap_out` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`dom_id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Now the check for this table works fine. So i want to do the same with watchdog_sys_stat. But i don´t find the structure. Who can me help to repair the table or make a new one?

Thanks, Klaus
 
Back
Top