質問編集履歴
3
質問の変更
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
|
1
|
+
mysqlのibdataについて
|
test
CHANGED
@@ -1,63 +1,13 @@
|
|
1
|
-
|
1
|
+
原因はわかりませんが、xampp mysqlのibdata1が2014年のものになっていて、2015年移行に作成したテーブルがすべて利用できない状態になってしまいました。
|
2
2
|
|
3
3
|
|
4
4
|
|
5
|
-
|
5
|
+
テーブルのibdとfrmはすべて残っているのですが、
|
6
6
|
|
7
|
-
|
7
|
+
ibdataがなければデータ取り出すことは不可能でしょうか?
|
8
|
-
|
9
|
-
0. mysqlの起動に成功
|
10
|
-
|
11
|
-
0. バックアップしていたmysqlのデータが入って居るdataフォルダを適用
|
12
|
-
|
13
|
-
0. 起動できず、dataフォルダ内に問題があることが判明
|
14
|
-
|
15
|
-
0. 昨日作ったテーブル名のフォルダに、サイズ0KBの「#sql-1bd0_9b.ibd」があるので、削除してみる。
|
16
|
-
|
17
|
-
0. 起動に成功したが、自分で作成した8つのテーブルすべて「 #1146 - Table 'テーブル名' doesn't exist」の状態でアクセスできず
|
18
8
|
|
19
9
|
|
20
10
|
|
21
|
-
解
|
11
|
+
先ほどまで、ibdata1の存在理由を理解しておらずテーブルのフォルダのみしかバックアップをとっていない状態でした。
|
22
12
|
|
23
|
-
|
24
|
-
|
25
|
-
|
26
|
-
|
27
|
-
xamppエラ-ログ
|
28
|
-
|
29
|
-
```
|
30
|
-
|
31
|
-
2015-12-01 15:54:24 14988 [Note] Plugin 'FEDERATED' is disabled.
|
32
|
-
|
33
|
-
2015-12-01 15:54:24 2d04 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
|
34
|
-
|
35
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Using atomics to ref count buffer pool pages
|
36
|
-
|
37
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: The InnoDB memory heap is disabled
|
38
|
-
|
39
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
|
40
|
-
|
41
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
42
|
-
|
43
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Not using CPU crc32 instructions
|
44
|
-
|
45
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Initializing buffer pool, size = 16.0M
|
46
|
-
|
47
|
-
2015-12-01 15:54:24 14988 [Note] InnoDB: Completed initialization of buffer pool
|
48
|
-
|
49
|
-
2015-12-01 15:54:25 14988 [Note] InnoDB: Highest supported file format is Barracuda.
|
50
|
-
|
51
|
-
2015-12-01 15:54:25 14988 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 1626154 in the ib_logfiles!
|
52
|
-
|
53
|
-
2015-12-01 15:54:25 14988 [Note] InnoDB: Database was not shutdown normally!
|
54
|
-
|
55
|
-
2015-12-01 15:54:25 14988 [Note] InnoDB: Starting crash recovery.
|
56
|
-
|
57
|
-
2015-12-01 15:54:25 14988 [Note] InnoDB: Reading tablespace information from the .ibd files...
|
58
|
-
|
59
|
-
2015-12-01 15:54:25 14988 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
|
60
|
-
|
61
|
-
|
62
|
-
|
63
|
-
```
|
13
|
+
解決方法があればお願いします。
|
2
文章の追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -19,6 +19,8 @@
|
|
19
19
|
|
20
20
|
|
21
21
|
解決が難しい状態です。なにかヒントでもよろしくお願いします。
|
22
|
+
|
23
|
+
mysqlのdataフォルダからデータを取り出す方法だけでも教えていただけると助かります。
|
22
24
|
|
23
25
|
|
24
26
|
|
1
エラーログ追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -19,3 +19,43 @@
|
|
19
19
|
|
20
20
|
|
21
21
|
解決が難しい状態です。なにかヒントでもよろしくお願いします。
|
22
|
+
|
23
|
+
|
24
|
+
|
25
|
+
xamppエラ-ログ
|
26
|
+
|
27
|
+
```
|
28
|
+
|
29
|
+
2015-12-01 15:54:24 14988 [Note] Plugin 'FEDERATED' is disabled.
|
30
|
+
|
31
|
+
2015-12-01 15:54:24 2d04 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
|
32
|
+
|
33
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Using atomics to ref count buffer pool pages
|
34
|
+
|
35
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: The InnoDB memory heap is disabled
|
36
|
+
|
37
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
|
38
|
+
|
39
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
40
|
+
|
41
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Not using CPU crc32 instructions
|
42
|
+
|
43
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Initializing buffer pool, size = 16.0M
|
44
|
+
|
45
|
+
2015-12-01 15:54:24 14988 [Note] InnoDB: Completed initialization of buffer pool
|
46
|
+
|
47
|
+
2015-12-01 15:54:25 14988 [Note] InnoDB: Highest supported file format is Barracuda.
|
48
|
+
|
49
|
+
2015-12-01 15:54:25 14988 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 1626154 in the ib_logfiles!
|
50
|
+
|
51
|
+
2015-12-01 15:54:25 14988 [Note] InnoDB: Database was not shutdown normally!
|
52
|
+
|
53
|
+
2015-12-01 15:54:25 14988 [Note] InnoDB: Starting crash recovery.
|
54
|
+
|
55
|
+
2015-12-01 15:54:25 14988 [Note] InnoDB: Reading tablespace information from the .ibd files...
|
56
|
+
|
57
|
+
2015-12-01 15:54:25 14988 [ERROR] InnoDB: File (unknown): 'read' returned OS error 0. Cannot continue operation
|
58
|
+
|
59
|
+
|
60
|
+
|
61
|
+
```
|