- 追加された行はこの色です。
- 削除された行はこの色です。
#author("2021-02-16T15:32:25+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]);