![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2021-02-16T15:35:23+09:00","default:kuji","kuji") #author("2021-02-16T16:15:00+09:00","default:kuji","kuji") CONTENTS #contents ---- Lastmodified &lastmod; ---- * Table './BB3/phpbb_config' is marked as crashed and should be repaired (145) [#ma17ec33] MySQL を5.7から8.0にUPしたのでDBのフルバックアップをしましょう。 # mysqldump -v -u root -p -x --all-databases > dump_ALL.sql Enter password:hogehoge -- Connecting to localhost... Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions, even those that changed suppressed parts of the database. If you don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers --routines --events. -- Retrieving table structure for table columns_priv... -- Sending SELECT query... -- Retrieving rows... -- Retrieving table structure for table component... -- Sending SELECT query... : : : : : : : : : -- Retrieving rows... -- Retrieving table structure for table phpbb_bots... -- Sending SELECT query... -- Retrieving rows... -- Retrieving table structure for table phpbb_config... mysqldump: Couldn't execute 'show create table `phpbb_config`': Table './BB3/phpbb_config' is marked as crashed and should be repaired (145) と、エラーで、STOP。 【確認】 # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 Server version: 8.0.23 Source distribution Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@localhost [(none)]> use BB3 Database changed root@localhost [BB3]> check table 'phpbb_config'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''phpbb_config'' at line 1 root@localhost [BB3]> check table phpbb_config; +------------------+-------+----------+----------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +------------------+-------+----------+----------------------------------------------------------+ | BB3.phpbb_config | check | warning | Table is marked as crashed | | BB3.phpbb_config | check | warning | 4 clients are using or haven't closed the table properly | | BB3.phpbb_config | check | status | OK | +------------------+-------+----------+----------------------------------------------------------+ 3 rows in set (0.03 sec) 【修復】 root@localhost [BB3]> repair table phpbb_config -> ; +------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +------------------+--------+----------+----------+ | BB3.phpbb_config | repair | status | OK | +------------------+--------+----------+----------+ 1 row in set (0.01 sec) root@localhost [BB3]> ---- Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday); #counter([total|today|yesterday]);
