serverneuansatz 2005-07-24

|| |notice|myopinion|close||klml|klml_not|klml_opi|klml_clo||maex|maex_not|maex_opi|maex_clo||edma|edma_not|edma_opi|edma_clo||

{BOX(title=>Inhaltsverzeichnis, bg=>greu, align=>left)}{BOX}

2005-07-24 14:33 Sicherung von umija.org: tiki_files; tiki_images 2005-07-24 14:42 Sicherung MySQL 2005-07-24 14:51 Problem Sicherung tiki_mysqlDB: Supplied argument is not a valid MySQL result resource in /usr/share/phpmyadmin/libraries/build_dump.lib.php on line 74 MySQL meldet: Can't open file: 'tiki_searchindex.MYD'. (errno: 145) 2005-07-24 15:03 tiki repariert:

mysql> CHECK TABLE tiki_searchindex -> ; +-----------------------+-------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------+-------+----------+---------------------------------------------------------+ | tiki.tiki_searchindex | check | warning | Table is marked as crashed | | tiki.tiki_searchindex | check | warning | 33 clients is using or hasn't closed the table properly | | tiki.tiki_searchindex | check | error | Record at pos: 15624 is not remove-marked | | tiki.tiki_searchindex | check | error | record delete-link-chain corrupted | | tiki.tiki_searchindex | check | error | Corrupt | +-----------------------+-------+----------+---------------------------------------------------------+ 5 rows in set (0.03 sec)

Ausgabe von REPAIR TABLE:

mysql> REPAIR TABLE tiki_searchindex -> ; +-----------------------+--------+----------+--------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------+--------+----------+--------------------------------------------+ | tiki.tiki_searchindex | repair | warning | Number of rows changed from 27968 to 27916 | | tiki.tiki_searchindex | repair | status | OK | +-----------------------+--------+----------+--------------------------------------------+ 2 rows in set (1.83 sec)

2005-07-24 15:03 tiki gesichert 2005-07-24 15:05 mysql, tiki, zabbix wurden gesichert 2005-07-24 15:06 Backup geht nicht da keine rootRechte 2005-07-24 15:11 backups vom 2005-07-16 bis 2005-07-24 von umija gezogen, da nicht "normal" gesichert 2005-07-24 15:14 resetversuch umija; fehlgeschlagen da rootpassword benötigt wird 2005-07-24 15:17 "letzte anmeldung root 2005-07-23 14:49:47 +0200" 2005-07-24 15:28 der Böse "dialup113.expert.ro" und 211.115.123.62 2005-07-24 16:02

DB Reparatur

Ausgabe von CHECK TABLE:

mysql> CHECK TABLE tiki_searchindex -> ; +-----------------------+-------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------+-------+----------+---------------------------------------------------------+ | tiki.tiki_searchindex | check | warning | Table is marked as crashed | | tiki.tiki_searchindex | check | warning | 33 clients is using or hasn't closed the table properly | | tiki.tiki_searchindex | check | error | Record at pos: 15624 is not remove-marked | | tiki.tiki_searchindex | check | error | record delete-link-chain corrupted | | tiki.tiki_searchindex | check | error | Corrupt | +-----------------------+-------+----------+---------------------------------------------------------+ 5 rows in set (0.03 sec)

Ausgabe von REPAIR TABLE:

mysql> REPAIR TABLE tiki_searchindex -> ; +-----------------------+--------+----------+--------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------+--------+----------+--------------------------------------------+ | tiki.tiki_searchindex | repair | warning | Number of rows changed from 27968 to 27916 | | tiki.tiki_searchindex | repair | status | OK | +-----------------------+--------+----------+--------------------------------------------+ 2 rows in set (1.83 sec)

Ausgabe von last | grep root:

root pts/0 dialup113.expert Sat Jul 23 14:49 - 14:49 (00:00) root pts/2 dialup113.expert Sat Jul 23 08:16 - 08:27 (00:10) root pts/0 211.115.123.62 Sat Jul 23 07:53 - 08:24 (00:30) root pts/3 p83.129.174.32.t Mon Jul 18 11:11 - 11:24 (00:12) root pts/0 p83.129.176.73.t Sat Jul 16 09:02 - 12:00 (02:58) root pts/1 p83.129.189.122. Mon Jul 11 10:41 - crash (07:54)