菜鸟也要有理想
中级会员
 
一般会员
UID 65342
精华
0
积分 439
帖子 426
金钱 439 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2005-8-1
状态 离线
|
mysql导入问题
平时都是使用mysqldump自动备份mysql
今天想要恢复
建立一个空的表
USE XXX
SOURCE XXX.sql
之后
导入的数据不完整
会提示
Query OK, 3587 rows affected (0.14 sec)
Records: 3587 Duplicates: 0 Warnings: 0
Query OK, 3679 rows affected (0.14 sec)
Records: 3679 Duplicates: 0 Warnings: 0
Query OK, 3415 rows affected (0.13 sec)
Records: 3415 Duplicates: 0 Warnings: 0
Query OK, 3809 rows affected (0.16 sec)
Records: 3809 Duplicates: 0 Warnings: 0
Query OK, 4330 rows affected (0.16 sec)
Records: 4330 Duplicates: 0 Warnings: 0
Query OK, 3736 rows affected (0.14 sec)
Records: 3736 Duplicates: 0 Warnings: 0
Query OK, 3450 rows affected (0.14 sec)
Records: 3450 Duplicates: 0 Warnings: 0
Query OK, 3477 rows affected (0.14 sec)
Records: 3477 Duplicates: 0 Warnings: 0
Query OK, 3642 rows affected (0.14 sec)
Records: 3642 Duplicates: 0 Warnings: 0
Query OK, 3703 rows affected (0.14 sec)
Records: 3703 Duplicates: 0 Warnings: 0
Query OK, 3562 rows affected (0.14 sec)
Records: 3562 Duplicates: 0 Warnings: 0
Query OK, 4075 rows affected (0.14 sec)
Records: 4075 Duplicates: 0 Warnings: 0
Query OK, 3581 rows affected (0.13 sec)
Records: 3581 Duplicates: 0 Warnings: 0
怎么解决
|
|
