![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2021-02-16 (火) 16:15:00
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 734：本日 1：昨日 0
