27 mysql存储引擎 engine=myisam 续3

表中的数据格式是可以移植的，所以表文件可以被拷贝到目录下

操作如下


创建一个表

mysql> create database test1;
Query OK, 1 row affected (0.02 sec)

mysql> use test1;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table t (id int,msg char(10));
Query OK, 0 rows affected (0.02 sec)

向表中写入数据

mysql> insert into t values(1,'a');
Query OK, 1 row affected (0.00 sec)

mysql> insert into t values(2,'b');
Query OK, 1 row affected (0.00 sec)

mysql> insert into t values(3,'c');
Query OK, 1 row affected (0.00 sec)

查看表中数据

mysql> select * from t;
+------+------+
| id   | msg  |
+------+------+
|    1 | a    |
|    2 | b    |
|    3 | c    |
+------+------+
3 rows in set (0.00 sec)

因为myisam会缓存，所以需要关闭服务器后，然后复制

ywx@ywx:/opt/mysql5151/data$ cp ./test1/* ./test11/

数据库中，看到全部的数据都拷贝过来了

mysql> use test11
Database changed
mysql> select * from t;
+------+------+
| id   | msg  |
+------+------+
|    1 | a    |
|    2 | b    |
|    3 | c    |
+------+------+
3 rows in set (0.00 sec)