teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップCentOSに関する質問mariaDBのデータ復活

編集履歴

回答編集履歴

3

余計な確認ログを削除

2020/11/13 14:45

投稿

退会済みユーザー
answer CHANGED
@@ -5,8 +5,6 @@
5
5
  [root@ ~]# systemctl status mariadb|grep PID
6
6
  Main PID: 13358 (mysqld)
7
7
 
8
- [root@ ~]#
9
-
10
8
  [root@ ~]# ls /proc/13358/fd -l|grep ibdata
11
9
  lrwx------ 1 mysql mysql 64 Nov 13 22:49 3 -> /var/lib/mysql/ibdata1
12
10
 

2

余計な確認ログを削除

2020/11/13 14:45

投稿

退会済みユーザー
answer CHANGED
@@ -25,12 +25,4 @@
25
25
  [root@ ~]# md5sum ibdata1.restored
26
26
  3e61e6f2fa41f409a554883717fcf110 ibdata1.restored
27
27
 
28
- [root@ ~]# chmod 666 ibdata1.restored
29
- [root@ ~]# mv ibdata1.restored /var/lib/mysql/ibdata1
30
-
31
- [root@ ~]# systemctl restart mariadb
32
- [root@ ~]# systemctl status mariadb
33
- ● mariadb.service - MariaDB 10.3 database server
34
- Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
35
- Active: active (running) since Fri 2020-11-13 22:51:59 JST; 4s ago
36
28
  ```

1

実行例をわかりやすく修正

2020/11/13 14:44

投稿

退会済みユーザー
answer CHANGED
@@ -1,21 +1,36 @@
1
1
  もし、現在もまだmariadbがopen中のファイルであれば、下記で復旧できませんか？
2
2
 
3
- ```console
3
+ ```
4
+ ◆削除前
4
- # systemctl status mariadb|grep PID
5
+ [root@ ~]# systemctl status mariadb|grep PID
5
- Main PID: 31585 (mysqld)
6
+ Main PID: 13358 (mysqld)
6
7
 
7
- # ls -l /proc/31585/fd |grep ibdata
8
+ [root@ ~]#
8
- lrwx------. 1 mysql mysql 64 Nov 6 16:09 6 -> /hoge/fuga/ibdata1
9
9
 
10
- # cp /proc/31585/fd/6 ibdata1.restored
10
+ [root@ ~]# ls /proc/13358/fd -l|grep ibdata
11
+ lrwx------ 1 mysql mysql 64 Nov 13 22:49 3 -> /var/lib/mysql/ibdata1
11
12
 
12
- # ls -lrt ibdata1.restored
13
- -rw-r-----. 1 root root 12582912 Nov 13 17:32 ibdata1.restored
13
+ [root@ ~]# md5sum /var/lib/mysql/ibdata1
14
+ 3e61e6f2fa41f409a554883717fcf110 /var/lib/mysql/ibdata1
14
15
 
15
- # md5sum ibdata1.restored
16
+ ◆削除後
16
- 5d3c319c883eb171fef39d6e55e6b2a1 ibdata1.restored
17
+ [root@ ~]# rm /var/lib/mysql/ibdata1
18
+ rm: remove regular file '/var/lib/mysql/ibdata1'? y
17
19
 
20
+ [root@ ~]# ls /proc/13358/fd -l|grep ibdata
21
+ lrwx------ 1 mysql mysql 64 Nov 13 22:49 3 -> /var/lib/mysql/ibdata1 (deleted)
18
22
 
23
+ ◆復旧
19
- # md5sum /hoge/fuga/ibdata1
24
+ [root@ ~]# cp /proc/13358/fd/3 ibdata1.restored
25
+ [root@ ~]# md5sum ibdata1.restored
26
+ 3e61e6f2fa41f409a554883717fcf110 ibdata1.restored
27
+
28
+ [root@ ~]# chmod 666 ibdata1.restored
20
- 5d3c319c883eb171fef39d6e55e6b2a1 /hoge/fuga/ibdata1
29
+ [root@ ~]# mv ibdata1.restored /var/lib/mysql/ibdata1
30
+
31
+ [root@ ~]# systemctl restart mariadb
32
+ [root@ ~]# systemctl status mariadb
33
+ ● mariadb.service - MariaDB 10.3 database server
34
+ Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
35
+ Active: active (running) since Fri 2020-11-13 22:51:59 JST; 4s ago
21
36
  ```