MySQL对innodb某一个表进行移动
（步骤：建表，禁用表空间，复制表空间，重用表空间)
mysql> desc test;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| name | varchar(20) | NO | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> use move_test;
Database changed
mysql> create table test(id int not null primary key,name varchar(20) not null) ;
mysql> system cp /mnt/data/mysql/data/reading/test.ibd /mnt/data/mysql/data/move_test/
mysql> system chown -R mysql:mysql /mnt/data/mysql/data/move_test/test.idb
mysql> alter table test import tablespace;
Query OK, 0 rows affected, 1 warning (0.12 sec)
mysql> select database();
+------------+
| database() |
+------------+
| move_test |
+------------+
1 row in set (0.00 sec)
mysql> select * from test;
+----+------+
| id | name |
+----+------+
| 1 | a |
| 2 | b |
| 3 | c |
+----+------+
3 rows in set (0.00 sec)
优质内容筛选与推荐>>
1、MySQL按天，按周，按月，按时间段统计
2、eWebEditor不支持IE8的解决方法[js报错：缺少对象 editor.js]
3、Server_Tomcat
4、学习ASP和编程的28个观点
5、iOS Programming Auto Layout: Programmatic Constraints 自动布局：通过编程限制
1、MySQL按天，按周，按月，按时间段统计
2、eWebEditor不支持IE8的解决方法[js报错：缺少对象 editor.js]
3、Server_Tomcat
4、学习ASP和编程的28个观点
5、iOS Programming Auto Layout: Programmatic Constraints 自动布局：通过编程限制