\u5728A\u670d\u52a1\u5668\u4e0a\u521b\u5efa\u6570\u636e\u5e93linuxidc
\nroot(yoon)> show create table linuxidc\\G
\n*************************** 1. row ***************************
\nTable: linuxidc
\nCreate Table: CREATE TABLE `linuxidc` (
\n`id` int(11) DEFAULT NULL,
\n`name` varchar(20) DEFAULT NULL
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8<\/p>\n
\u63d2\u5165\u6570\u636e
\nroot(linuxidc)> insert into linuxidc values (1,’HANK’);
\nQuery OK, 1 row affected (1.01 sec)
\nroot(linuxidc)> insert into linuxidc values (2,’linuxidc’);
\nQuery OK, 1 row affected (0.04 sec)
\nroot(linuxidc)> insert into linuxidc values (3,’GARY’);
\nQuery OK, 1 row affected (0.00 sec)
\nroot(linuxidc)> insert into linuxidc values (4,’NIKO’);
\nQuery OK, 1 row affected (0.02 sec)
\nroot(linuxidc)> select * from linuxidc;
\n+——+——+
\n| id\u00a0 | name |
\n+——+——+
\n|\u00a0 \u00a0 1 | HANK |
\n|\u00a0 \u00a0 2 | linuxidc |
\n|\u00a0 \u00a0 3 | GARY |
\n|\u00a0 \u00a0 4 | NIKO |
\n+——+——+
\n4 rows in set (0.00 sec)<\/p>\n
\u5728B\u670d\u52a1\u5668\u4e0a\uff0c\u6dfb\u52a0\u53c2\u6570innodb_force_recovery=1\u5e76\u91cd\u542f\uff0c\u521b\u5efa\u7a7a\u6570\u636e\u5e93linuxidc\uff0c\u5e76\u521b\u5efa\u8868yoon
\nmysql> create database linuxidc;
\nuse yooQuery OK, 1 row affected (1.01 sec)
\nmysql> use linuxidc;
\nDatabase changed
\nmysql> CREATE TABLE `linuxidc` (
\n->\u00a0 `id` int(11) DEFAULT NULL,
\n->\u00a0 `name` varchar(20) DEFAULT NULL
\n-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\nQuery OK, 0 rows affected (0.09 sec)<\/p>\n
\u5c06\u8868\u7ed3\u6784\u548c\u7a7a\u95f4\u8131\u79bb
\nmysql> alter table linuxidc discard tablespace;
\nQuery OK, 0 rows affected (0.02 sec)<\/p>\n
\u5c06A\u670d\u52a1\u5668\u4e0a\u7684ibd\u6570\u636e\u6587\u4ef6\u4f20\u8f93\u81f3B\u670d\u52a1\u5668\u4e0a
\nscp linuxidc.ibd 182.19.4.7:\/export\/data\/mysql\/data\/linuxidc<\/p>\n
\u4fee\u6539\u6743\u9650
\nchown -R mysql.mysql linuxidc.ibd<\/p>\n
\u5c06\u8868\u7ed3\u6784\u548c\u7a7a\u95f4\u5efa\u7acb\u5173\u7cfb
\nmysql> alter table linuxidc import tablespace;
\nQuery OK, 0 rows affected, 1 warning (0.04 sec)<\/p>\n
\u67e5\u8be2\u6570\u636e
\nmysql> select * from linuxidc;
\n+——+——+
\n| id\u00a0 | name |
\n+——+——+
\n|\u00a0 \u00a0 1 | HANK |
\n|\u00a0 \u00a0 2 | linuxidc |
\n|\u00a0 \u00a0 3 | GARY |
\n|\u00a0 \u00a0 4 | NIKO |
\n+——+——+
\n4 rows in set (0.00 sec)<\/p>\n
\u8be6\u7ec6\u6b65\u9aa4\u5982\u4e0b\uff1a
\n1\u3001\u505c\u6b62mysql\u670d\u52a1\uff0c\u6dfb\u52a0innodb_force_recovery=1 \uff0c\u542f\u52a8mysql\u670d\u52a1
\n2\u3001\u521b\u5efa\u65b0\u6570\u636e\u5e93\uff0c\u521b\u5efa\u76f8\u540c\u8868\u7ed3\u6784\u7684\u8868\uff08\u8868\u7ed3\u6784\u5fc5\u987b\u76f8\u540c\uff09
\n3\u3001\u6267\u884calter table tb discard tablespace;
\n4\u3001\u5220\u9664\u8868\u7684ibd\u6587\u4ef6
\n5\u3001\u8de8\u670d\u52a1\u5668\u590d\u5236\u8868ibd\u6587\u4ef6
\n6\u3001\u4fee\u6539ibd\u6587\u4ef6\u6743\u9650,\u6267\u884calter table tb import tablespace;<\/p>\n","protected":false},"excerpt":{"rendered":"