直接把frm、MYI、MYD这几个文件放到装mysql的文件夹data/数据库名 目录下,怎么数据文件加载不上来呀? 直接把frm、MYI、MYD这几个文件放到装mysql的文件夹data/数据库名 目录下,怎么数据文件加载不上来呀?能不能像sql server2000那样附加数据库一样附加进来呢,在MYsql里面?急.... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不好意思,刚才没把错误信息附加上来:如下mysql> show tables;+----------------+| Tables_in_test |+----------------+| ebs_book || ebs_customer || ebs_order || ebs_orderline |+----------------+4 rows in set (0.00 sec)mysql> desc ebs_book;ERROR 1034 (HY000): Incorrect key file for table 'ebs_book'; try to repair it 用 mysqlcheck 命令修复一下。mysqlcheck -r -u root -p123 dbname tablenamemysqlcheck -r -u root -p123 dbname ebs_book 把mysql stop 后,在start 试试 或者在操作系统命令下用 mysqlcheck或者在mysql中mysql> REPAIR TABLE ebs_book; 不好意思,是ibdata1,里面保存着数据记录 试了楼上朋友的做法,还是不行: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! 在MYSQL中是通过MYSQLDUMP备份再导入的,直接COPY有问题 多谢提示:可我没有它的ibdata1,只有我建数据库的ibdata1,难道是这原因?无奈,无法操作,因为没文件 在原来的系统上用MYSQLDUMP 备份试试,原来的系统出问题了? 我只有:ebs_book.frm/ebs_book.myi/ebs_book.myd 这三个文件,其它什么都没有..如果愿意帮忙,我可以发原这三个文件过去...我邮箱 [email protected] 多谢... 你可以试一下:直接放到MySQL的data\数据库名\下,重新启动一下MySQL,看看能否读取,如不能,就不要浪费时间的。 试试myisamchk --safe-recover c:\mysql\data\hw_enterprice\ebs_book.myi能否修复 上传你的文件到www.access911.net/csdn用WINRAR压缩 已经上传了,名字为test.rar 上传时间为:2009-4-23 15:49:04多谢... 只测试ebs_book 表,将三个文件COPY 到MYSQL的DATA文件夹下,启动MYSQL后,可以正确读取,下述是导出的SQL,你看看是否正确*SQLyog Enterprise - MySQL GUIMySQL - 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); *SQLyog Enterprise - MySQL GUIMySQL - 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'); /*SQLyog Enterprise - MySQL GUIMySQL - 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'); /*SQLyog Enterprise - MySQL GUIMySQL - 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','','',''); 看看是否正确,可以直接COPY上述代码,PASTE到MYSQL中执行 朋友你好厉害哦,我是初学,好多软件都没用上,看完帖后,刚下了SQLyog community版的 - MySQL GUI 导出数据SQL时还是不行:error number:1034error messages:Incorrect key file for table 'ebs_book'; try to repair it能不能再具体说详细点呀..比如放上您操作过程的执行语句,用的哪款软件?..顺便介绍几款有关操作MYSQL的工具软件吧...忠心感谢呀..可能是我功力不够,才没学半个月...哈哈不怕你笑话...很高兴用您给出的SQL语句可以在我机上执行,并建表了,当然没了数据.. 1、首先确定你的DATA文件夹在什么地方,后将你frm、MYI、MYD文件COPY到数据库文件中,比如TEST,这里MYSQL没有启动;2、启动MYSQL,这时应该看到这些表了,我用的就是SQLYOG;3、将我上述的SQL语句COPY、PASTE到SQLYOG中,按SHIFT+F9执行;4、当然没了数据:为什么?上述SQL语句中INSERT就是插入数据;5、SQLYOG应该不错。 楼主,把你的my.ini文件内容贴出来。在这个INI文件中定义了你的数据文件的路径。datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"然后在这个文件夹中会有你数据库名字命名的子文件夹。把你的这些文件复制到里面就行了。 关于25楼朋友的提示,这个我已经操作过了...这几天忙着论文的事,没来结贴,抱歉哦!在这真的非常感谢大家的指导!在这特别感谢"ACMAIN_CHM" 和 "WWWWA"! 尤其是"WWWWA"! 查询出某个节点下的所有树枝节点 求... MYSQL 表框架更改问题! 求救!存储过程出错 为什么我的的mysql不能用 这个查询语句怎么写?(查询在另一张表中的字段值包含某一张表的哪些字段名) mysql的ODBC数据源连接问题。 关于数据库恢复问题 谁会写mysql.sock这个脚本? 在access sql中怎么实现mysql的sql语句select * from user where id>1 order by id DESC limit 3,10????? 求指教第一次安装配置解压版Mysql5.7.9 MySql的存储过程的性能怎么样? 帮忙看看 我这个数据库怎么设置主键
+----------------+
| Tables_in_test |
+----------------+
| ebs_book |
| ebs_customer |
| ebs_order |
| ebs_orderline |
+----------------+
4 rows in set (0.00 sec)mysql> desc ebs_book;
ERROR 1034 (HY000): Incorrect key file for table 'ebs_book'; try to repair it
mysqlcheck -r -u root -p123 dbname ebs_book
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!
直接放到MySQL的data\数据库名\下,重新启动一下MySQL,看看能否读取,
如不能,就不要浪费时间的。
myisamchk --safe-recover c:\mysql\data\hw_enterprice\ebs_book.myi
能否修复
www.access911.net/csdn
用WINRAR压缩
正确读取,下述是导出的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);
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');
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');
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','','','');
error messages:Incorrect key file for table 'ebs_book'; try to repair it能不能再具体说详细点呀..比如放上您操作过程的执行语句,用的哪款软件?..顺便介绍几款有关操作MYSQL的工具软件吧...忠心感谢呀..可能是我功力不够,才没学半个月...哈哈不怕你笑话...很高兴用您给出的SQL语句可以在我机上执行,并建表了,当然没了数据..
文件COPY到数据库文件中,比如TEST,这里MYSQL没有启动;
2、启动MYSQL,这时应该看到这些表了,我用的就是SQLYOG;
3、将我上述的SQL语句COPY、PASTE到SQLYOG中,按SHIFT+F9执行;
4、当然没了数据:为什么?上述SQL语句中INSERT就是插入数据;
5、SQLYOG应该不错。