直接把frm、MYI、MYD这几个文件放到装mysql的文件夹data/数据库名 目录下，怎么数据文件加载不上来呀？

[Snooke]

直接把frm、MYI、MYD这几个文件放到装mysql的文件夹data/数据库名 目录下，怎么数据文件加载不上来呀？

能不能像sql server2000那样附加数据库一样附加进来呢，在MYsql里面？

急....

[lacasadeco]

需要把IBDATE文件夹拷过来

[lacasadeco]

不好意思，是ibdata1，里面保存着数据记录

[Snooke]

试了楼上朋友的做法,还是不行:
mysql> repair table ebs_book;
+---------------+--------+----------+--------------------
| Table | Op | Msg_type | Msg_text
|
+---------------+--------+----------+-------------------------------------------

| test.ebs_book | repair | Error | Incorrect key file for table 'ebs_book'; try to repair it |
| test.ebs_book | repair | error | Corrupt

+---------------+--------+----------+-------------------------------------------


刚查到一篇文章,显示楼上朋友的做法只对MYISAM格式的表有效.如下:

下面讲的方法只对MyISAM格式的表有效。其他类型的损坏需要从备份中恢复。
1,REPAIR TABLE SQL statement(mysql服务必须处于运行状态)。
2,命令mysqlcheck(mysql服务可以处于运行状态)。
3,命令myisamchk(必须停掉mysql服务,或者所操作的表处于不活动状态)。


我装数据库默认是InnoDB格式,拷的文件又不知道原来的存储格式,这怎么办?
如上的方法说:"其他类型的损坏需要从备份中恢复",这又是什么意思呀?
上面出错信息显示是"Corrupt",难道文件彻底损坏了?

MySQL附加个数据都这么难,最近和SUN一起又被Oracle收购,到底我应该继续学它、用它，还是转学其它数据库呀...茫然！

加分到50！

[WWWWA]

在MYSQL中是通过MYSQLDUMP备份再导入的，直接COPY有问题

[Snooke]

多谢提示：可我没有它的ibdata1，只有我建数据库的ibdata1，难道是这原因？

无奈，无法操作，因为没文件

[WWWWA]

在原来的系统上用MYSQLDUMP 备份试试，原来的系统出问题了？

[Snooke]

我只有:ebs_book.frm/ebs_book.myi/ebs_book.myd 这三个文件,其它什么都没有..

如果愿意帮忙,我可以发原这三个文件过去...我邮箱 [e-mail]

多谢...

[WWWWA]

你可以试一下：
直接放到MySQL的data\数据库名\下,重新启动一下MySQL，看看能否读取，
如不能，就不要浪费时间的。

[WWWWA]

试试
myisamchk --safe-recover c:\mysql\data\hw_enterprice\ebs_book.myi
能否修复

[WWWWA]

上传你的文件到
www.access911.net/csdn
用WINRAR压缩

[Snooke]

已经上传了,名字为test.rar 上传时间为:2009-4-23 15:49:04

多谢...

[WWWWA]

只测试ebs_book 表，将三个文件COPY 到MYSQL的DATA文件夹下，启动MYSQL后，可以
正确读取，下述是导出的SQL，你看看是否正确
*
SQLyog Enterprise - MySQL GUI
MySQL - 5.1.17-beta-community-nt-debug
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `ebs_book` (
`isbn` varchar (30),
`title` varchar (90),
`author` varchar (30),
`publisher` varchar (45),
`price` float ,
`description` varchar (300)
);
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('101','JSP application development','feisi',NULL,'55',NULL);
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('102','J2EE application development','zhao qian',NULL,'45',NULL);
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('103','Master Strutst','feisi',NULL,'50',NULL);
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('104','精通SSH','梁立新','电子工业出版社','49','一本最新书籍');
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('105','J2ME','lxl','sss','45',NULL);
insert into `ebs_book` (`isbn`, `title`, `author`, `publisher`, `price`, `description`) values('106','J2SE','Lixin','出','39',NULL);

[WWWWA]

*
SQLyog Enterprise - MySQL GUI
MySQL - 5.1.17-beta-community-nt-debug
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `ebs_orderline` (
`oid` double ,
`isbn` varchar (30),
`baseprice` float ,
`quantity` double
);
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('7','103','50','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('7','101','55','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('8','101','55','4');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('9','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('10','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('10','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('11','103','50','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('11','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('11','102','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('12','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('12','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('13','103','50','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('13','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('13','102','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('14','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('14','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('15','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('15','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('16','101','55','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('16','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('17','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('18','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('18','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('19','101','55','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('19','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('20','103','50','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('20','104','49','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('20','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('21','104','49','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('22','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('22','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('23','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('23','102','45','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('23','106','39','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('24','105','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('25','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('25','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('25','106','39','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('26','104','49','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('26','106','39','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('27','105','45','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('28','105','45','3');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('28','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('29','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('29','104','49','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('30','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('30','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('31','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('31','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('32','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('32','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('33','105','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('33','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('34','105','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('34','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('34','106','39','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('35','105','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('35','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('36','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('36','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('37','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('37','104','49','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('37','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('38','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('39','105','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('39','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('40','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('41','101','55','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('41','102','45','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('41','106','39','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('42','101','55','1');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('42','102','45','2');
insert into `ebs_orderline` (`oid`, `isbn`, `baseprice`, `quantity`) values('42','106','39','2');

[WWWWA]

/*
SQLyog Enterprise - MySQL GUI
MySQL - 5.1.17-beta-community-nt-debug
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `ebs_order` (
`oid` double ,
`title` varchar (15),
`custname` varchar (30),
`address` varchar (150),
`user` varchar (30),
`date` date ,
`booklist` varchar (150),
`price` float
);
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('1','Mr.','zhang','beijing','user1','2005-07-07','','100');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('2','null','Lixin','12 erefsddsds','null','0000-00-00','','320');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('3','null','sss','sssss','null','0000-00-00','','270');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('4','null','qaasas','wewedwdw','null','0000-00-00','103 101','320');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('5','null','Lixin','weereewwe','null','0000-00-00','103 101','365');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('6','null','fddfd','fdfddd','null','0000-00-00','103 101','265');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('7','null','ffgff','ghgh','null','0000-00-00','103 101','265');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('8','null','fxhn','khuiu','null','0000-00-00','101','220');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('9','null','12','aa','null','0000-00-00','101','55');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('10','null','aa','aa','null','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('11','null','ww','qq','null','0000-00-00','103 101 102','250');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('12','null','Liwei','fdfdfd','liwei','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('13','null','aa','aa','ll','0000-00-00','103 101 102','300');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('14','null','ll','llllll','liwei','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('15','null','hh','nn','user1','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('16','null','jj','jj','user1','0000-00-00','101 102','210');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('17','null','ss','aa','user1','0000-00-00','101','55');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('18','null','h','hh','user1','0000-00-00','101 102','100');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('19','null','j','trg','user1','0000-00-00','101 102','210');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('20','null','梁立新','222 留学人员创业园','梁立新','0000-00-00','103 104 102','144');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('21','null','立新','创业园','梁立新','0000-00-00','104','98');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('22','null','','','梁立新','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('23','null','','jj','Lixin','0000-00-00','101 102 106','229');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('24','null','rr','rr','Lixin','0000-00-00','105','90');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('25','null','aa','aa','Lixin','0000-00-00','101 102 106','178');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('26','null','y','y','Lixin','0000-00-00','104 106','88');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('27','null','','','Lixin','0000-00-00','105','135');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('28','null','ww','ee','Lixin','0000-00-00','105 102','180');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('29','null','梁立新','sdsdss','Lixin','0000-00-00','101 104','104');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('30','null','e','ee','Lixin','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('31','null','e','ee','Lixin','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('32','null','ee','ee','Lixin','0000-00-00','101 102','100');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('33','null','222','333','Lixin','0000-00-00','105 102','135');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('34','null','333','444','Lixin','0000-00-00','105 101 106','194');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('35','null','44','55','Lixin','0000-00-00','105 101','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('36','null','55','55','Lixin','0000-00-00','101 102','155');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('37','null','','','Lixin','0000-00-00','101 104 102','204');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('38','null','55','44','Lixin','0000-00-00','102','45');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('39','null','55','tt','Lixin','0000-00-00','105 102','135');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('40','null','rr','rr','Lixin','0000-00-00','101','110');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('41','null','Lixin','上地东路29号','Lixin','0000-00-00','101 102 106','194');
insert into `ebs_order` (`oid`, `title`, `custname`, `address`, `user`, `date`, `booklist`, `price`) values('42','null','Lixin333','3333','Lixin','0000-00-00','101 102 106','223');

[WWWWA]

/*
SQLyog Enterprise - MySQL GUI
MySQL - 5.1.17-beta-community-nt-debug
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `ebs_customer` (
`cid` double ,
`user` varchar (30),
`password` varchar (15),
`name` varchar (30),
`title` varchar (15),
`email` varchar (45)
);
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('1','user1','123','zhang','sir',NULL);
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('2','liwei','123','','',NULL);
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('4','ll','11','dss','dd','dd');
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('5','Lixin','223','ll','ll','ll@');
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('6','梁立新','123456','梁林','测试园','@@@');
insert into `ebs_customer` (`cid`, `user`, `password`, `name`, `title`, `email`) values('7','dd','ss','','','');

[WWWWA]

看看是否正确，可以直接COPY上述代码，PASTE到MYSQL中执行

[Snooke]

朋友你好厉害哦,我是初学,好多软件都没用上,看完帖后,刚下了SQLyog community版的 - MySQL GUI

导出数据SQL时还是不行:

error number:1034
error messages:Incorrect key file for table 'ebs_book'; try to repair it

能不能再具体说详细点呀..比如放上您操作过程的执行语句,用的哪款软件?..

顺便介绍几款有关操作MYSQL的工具软件吧...忠心感谢呀..

可能是我功力不够,才没学半个月...哈哈不怕你笑话...

很高兴用您给出的SQL语句可以在我机上执行,并建表了,当然没了数据..

[WWWWA]

1、首先确定你的DATA文件夹在什么地方，后将你frm、MYI、MYD
文件COPY到数据库文件中，比如TEST，这里MYSQL没有启动；
2、启动MYSQL，这时应该看到这些表了，我用的就是SQLYOG；
3、将我上述的SQL语句COPY、PASTE到SQLYOG中，按SHIFT+F9执行；
4、当然没了数据：为什么？上述SQL语句中INSERT就是插入数据；
5、SQLYOG应该不错。

[ACMAIN_CHM]

楼主，把你的my.ini文件内容贴出来。

在这个INI文件中定义了你的数据文件的路径。

datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

然后在这个文件夹中会有你数据库名字命名的子文件夹。把你的这些文件复制到里面就行了。

[Snooke]

关于25楼朋友的提示,这个我已经操作过了...

这几天忙着论文的事,没来结贴,抱歉哦!

在这真的非常感谢大家的指导!

在这特别感谢"ACMAIN_CHM" 和 "WWWWA"! 尤其是"WWWWA"!