is marked as crashed and should be repaired
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
* Table './BB3/phpbb_config' is marked as crashed and sho...
MySQL を5.7から8.0にUPしたのでDBのフルバックアップをしま...
# mysqldump -v -u root -p -x --all-databases > dump_ALL....
Enter password:hogehoge
-- Connecting to localhost...
Warning: A partial dump from a server that has GTIDs wil...
-- 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_co...
と、エラーで、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 a...
affiliates. Other names may be trademarks of their respe...
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the cu...
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...
root@localhost [BB3]> check table phpbb_config;
+------------------+-------+----------+-----------------...
| Table | Op | Msg_type | Msg_text ...
+------------------+-------+----------+-----------------...
| BB3.phpbb_config | check | warning | Table is marked ...
| BB3.phpbb_config | check | warning | 4 clients are us...
| 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([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
* Table './BB3/phpbb_config' is marked as crashed and sho...
MySQL を5.7から8.0にUPしたのでDBのフルバックアップをしま...
# mysqldump -v -u root -p -x --all-databases > dump_ALL....
Enter password:hogehoge
-- Connecting to localhost...
Warning: A partial dump from a server that has GTIDs wil...
-- 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_co...
と、エラーで、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 a...
affiliates. Other names may be trademarks of their respe...
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the cu...
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...
root@localhost [BB3]> check table phpbb_config;
+------------------+-------+----------+-----------------...
| Table | Op | Msg_type | Msg_text ...
+------------------+-------+----------+-----------------...
| BB3.phpbb_config | check | warning | Table is marked ...
| BB3.phpbb_config | check | warning | 4 clients are us...
| 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([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
