Hello... I have been running a server with ISPConfig3 for several years. A hard drive recently failed. After replacing the faulty drive, I was able to restore the RAID and the server started up normally again. I then noticed that monitoring was no longer working. There are also no log files. The "monitor-data" table in the "dbispconfig database" was read-only. It was not possible to repair it. I then deleted the table in the terminal in the hope that it would be created again during an update. But that was not the case. What is the best way to recreate this table? I now have a new server that I want to move to using the migration tool. However, I think there will be problems if the old server is faulty. Regards Enrico
Here is the SQL query to recreate it: Code: CREATE TABLE `monitor_data` ( `server_id` int(11) unsigned NOT NULL default '0', `type` varchar(255) NOT NULL default '', `created` int(11) unsigned NOT NULL default '0', `data` mediumtext, `state` enum('no_state','unknown','ok','info','warning','critical','error') NOT NULL DEFAULT 'unknown', PRIMARY KEY (`server_id`,`type`,`created`) ) DEFAULT CHARSET=utf8 ;
Hello Till, Thank you for your quick reply and help. The table was created successfully and the server immediately started creating logs again. Best regards Enrico
