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

編集履歴

回答編集履歴

3

余計な確認ログを削除

2020/11/13 14:45

投稿

退会済みユーザー
test CHANGED
@@ -9,10 +9,6 @@
9
9
  [root@ ~]# systemctl status mariadb|grep PID
10
10
 
11
11
  Main PID: 13358 (mysqld)
12
-
13
-
14
-
15
- [root@ ~]#
16
12
 
17
13
 
18
14
 

2

余計な確認ログを削除

2020/11/13 14:45

投稿

退会済みユーザー
test CHANGED
@@ -52,20 +52,4 @@
52
52
 
53
53
 
54
54
 
55
- [root@ ~]# chmod 666 ibdata1.restored
56
-
57
- [root@ ~]# mv ibdata1.restored /var/lib/mysql/ibdata1
58
-
59
-
60
-
61
- [root@ ~]# systemctl restart mariadb
62
-
63
- [root@ ~]# systemctl status mariadb
64
-
65
- ● mariadb.service - MariaDB 10.3 database server
66
-
67
- Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
68
-
69
- Active: active (running) since Fri 2020-11-13 22:51:59 JST; 4s ago
70
-
71
55
  ```

1

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

2020/11/13 14:44

投稿

退会済みユーザー
test CHANGED
@@ -2,40 +2,70 @@
2
2
 
3
3
 
4
4
 
5
- ```console
5
+ ```
6
6
 
7
- # systemctl status mariadb|grep PID
7
+ ◆削除前
8
8
 
9
+ [root@ ~]# systemctl status mariadb|grep PID
10
+
9
- Main PID: 31585 (mysqld)
11
+ Main PID: 13358 (mysqld)
10
12
 
11
13
 
12
14
 
13
- # ls -l /proc/31585/fd |grep ibdata
15
+ [root@ ~]#
14
-
15
- lrwx------. 1 mysql mysql 64 Nov 6 16:09 6 -> /hoge/fuga/ibdata1
16
16
 
17
17
 
18
18
 
19
- # cp /proc/31585/fd/6 ibdata1.restored
19
+ [root@ ~]# ls /proc/13358/fd -l|grep ibdata
20
+
21
+ lrwx------ 1 mysql mysql 64 Nov 13 22:49 3 -> /var/lib/mysql/ibdata1
20
22
 
21
23
 
22
24
 
23
- # ls -lrt ibdata1.restored
25
+ [root@ ~]# md5sum /var/lib/mysql/ibdata1
24
26
 
25
- -rw-r-----. 1 root root 12582912 Nov 13 17:32 ibdata1.restored
27
+ 3e61e6f2fa41f409a554883717fcf110 /var/lib/mysql/ibdata1
26
28
 
27
29
 
28
30
 
29
- # md5sum ibdata1.restored
31
+ ◆削除後
30
32
 
31
- 5d3c319c883eb171fef39d6e55e6b2a1 ibdata1.restored
33
+ [root@ ~]# rm /var/lib/mysql/ibdata1
34
+
35
+ rm: remove regular file '/var/lib/mysql/ibdata1'? y
32
36
 
33
37
 
34
38
 
39
+ [root@ ~]# ls /proc/13358/fd -l|grep ibdata
40
+
41
+ lrwx------ 1 mysql mysql 64 Nov 13 22:49 3 -> /var/lib/mysql/ibdata1 (deleted)
35
42
 
36
43
 
37
- # md5sum /hoge/fuga/ibdata1
38
44
 
45
+ ◆復旧
46
+
47
+ [root@ ~]# cp /proc/13358/fd/3 ibdata1.restored
48
+
49
+ [root@ ~]# md5sum ibdata1.restored
50
+
51
+ 3e61e6f2fa41f409a554883717fcf110 ibdata1.restored
52
+
53
+
54
+
55
+ [root@ ~]# chmod 666 ibdata1.restored
56
+
39
- 5d3c319c883eb171fef39d6e55e6b2a1 /hoge/fuga/ibdata1
57
+ [root@ ~]# mv ibdata1.restored /var/lib/mysql/ibdata1
58
+
59
+
60
+
61
+ [root@ ~]# systemctl restart mariadb
62
+
63
+ [root@ ~]# systemctl status mariadb
64
+
65
+ ● mariadb.service - MariaDB 10.3 database server
66
+
67
+ Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
68
+
69
+ Active: active (running) since Fri 2020-11-13 22:51:59 JST; 4s ago
40
70
 
41
71
  ```