- 论坛徽章:
- 0
|
20可用积分
很抱歉,首先声明一下:我对mysql不太熟,哈
有这样一个需求,就是按条件备份数据库中的一段数据,然后需要的时候,再把这段数据恢复到原先数据库的表中。
我使用mysqldump这样操作
mysqldump -uroot -p123456 --no-create-db=TRUE --no-create-info=TRUE --add-drop-table=FALSE --default-character-set="gbk" --where="record_time>='2009-03-2' and record_time<='2009-03-27'" db tbname
这样导出来的数据只有一天的,没有范围。。。。奇怪了。谁来帮个忙。
--
-- WHERE: record_time>='2009-03-2' and record_time<='2009-03-27'
LOCK TABLES `FDATE` WRITE;
/*!40000 ALTER TABLE `FDATE` DISABLE KEYS */;
INSERT INTO `FDATE` VALUES (776,'192.168.129.100.1235463300','и·??',3232268644,5400634,40724777,'2009-03-02'),(777,'192.168.129.102.1235464542','и·??',3232268646,7938883,13408769,'2009-03-02'),(778,'192.168.129.106.1235464990','?μ2?',3232268650,10697673,57677222,'2009-03-02'),(779,'192.168.129.11.1235415928','???,3232268555,124572671,18044122,'2009-03-02'),(780,'192.168.129.114.1235463112','??2?',3232268658,12877348,52062543,'2009-03-02'),(781,'192.168.129.117.1235464474','339j?',3232268661,39351109,52637658,'2009-03-02'),(782,'192.168.129.118.1235464309','339j?',3232268662,11848125,46596663,'2009-03-02'),(783,'192.168.129.12.1235463757','???,3232268556,146963219,32832934,'2009-03-02'),(784,'192.168.129.121.1235464640','?a·¢?
/*!40000 ALTER TABLE `FDATE` ENABLE KEYS */;
或者有什么别的好的方法,能达要求就可以。
1、导出
2、再导入 |
最佳答案
查看完整内容
· 当在从表中选择数据之时,你得到如下错误:· Incorrect key file for table: '...'. Try to repair it· 查询不能在表中找到行或返回不完全的数据。你可以用CHECK TABLE statement语句来检查MyISAM表的健康,并用REPAIR TABLE修复一个 损坏的MyISAM表。当mysqld不运行之时,你也可以用myisamchk命令检查或修理一个表。请参阅13.5.2.3节,"CHECK TABLE语法", 13.5.2.6节,"REPAIR TABLE语法", ...
|