小弟我刚入门MySQL,是这样的,我在实验室用MySQL建的数据库,数据库名:rfid 里面有 student.frm user.frm 等文件,在 C:\Program Files\MySQL\MySQL Server 5.0\data\rfid 下面;然后我把文件夹rfid 拷回宿舍电脑了,放到了C:\Program Files\MySQL\MySQL Server 5.0\data\ 这,怎么打开MySQL query browser 看不到了啊,提示 table "rfid.*" doesn't exist怎么回事啊? 数据库文件不可以拷贝的还是? 怎么解决呀?谢谢各位大大了~!!!
--
-- ------------------------------------------------------
-- Server version 5.0.27-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema rfid
--CREATE DATABASE IF NOT EXISTS rfid;
USE rfid;--
-- Definition of table `card`
--DROP TABLE IF EXISTS `card`;
CREATE TABLE `card` (
`cardno` int(10) unsigned NOT NULL,
`pwd` varchar(6) NOT NULL,
`balance` float unsigned zerofill NOT NULL,
`quato` int(10) unsigned NOT NULL,
`flag` int(11) NOT NULL,
PRIMARY KEY (`cardno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;--
-- Dumping data for table `card`
--/*!40000 ALTER TABLE `card` DISABLE KEYS */;
INSERT INTO `card` (`cardno`,`pwd`,`balance`,`quato`,`flag`) VALUES
(101201,'123456',000000000050,10,0),
(101202,'123456',000000000150,10,0),
(101203,'123456',000000000250,10,0),
(101204,'123456',000000000150,10,0),
(101205,'123456',000000000100,10,0),
(102201,'123456',000000000080,10,0),
(102202,'123456',000000000060,10,0),
(301201,'123456',000000000040,10,0),
(1056635538,'123456',000000000347,15,0);
/*!40000 ALTER TABLE `card` ENABLE KEYS */;
--
-- Definition of table `chargeinfo`
--DROP TABLE IF EXISTS `chargeinfo`;
CREATE TABLE `chargeinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`cardno` int(10) unsigned NOT NULL,
`num` float NOT NULL,
`time` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;--
-- Dumping data for table `chargeinfo`
--/*!40000 ALTER TABLE `chargeinfo` DISABLE KEYS */;
INSERT INTO `chargeinfo` (`id`,`cardno`,`num`,`time`) VALUES
(1,1056635538,25,'2010-05-21 20:34:45'),
(2,1056635538,15.5,'2010-05-22 09:20:41'),
(3,1056635538,1.5,'2010-05-22 09:43:07'),
(4,1056635538,15.5,'2010-05-22 10:55:08'),
(5,1056635538,50,'2010-05-22 18:41:03');
/*!40000 ALTER TABLE `chargeinfo` ENABLE KEYS */;
--
-- Definition of table `csinfo`
--DROP TABLE IF EXISTS `csinfo`;
CREATE TABLE `csinfo` (
`cardno` int(10) unsigned NOT NULL,
`num` float NOT NULL,
`time` varchar(45) NOT NULL,
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;--
-- Dumping data for table `csinfo`
--/*!40000 ALTER TABLE `csinfo` DISABLE KEYS */;
INSERT INTO `csinfo` (`cardno`,`num`,`time`,`id`) VALUES
(1056635538,4,'2010-05-22 10:57:17',1),
(1056635538,3.5,'2010-05-22 11:05:26',2),
(1056635538,5,'2010-05-22 11:06:24',3),
(1056635538,1.5,'2010-05-22 11:07:23',4),
(1056635538,2.5,'2010-05-22 11:08:07',5),
(1056635538,5,'2010-05-22 18:45:03',6),
(1056635538,5.5,'2010-05-22 18:45:39',7),
(1056635538,5,'2010-05-22 19:17:31',8);
/*!40000 ALTER TABLE `csinfo` ENABLE KEYS */;
--
-- Definition of table `student`
--DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`sno` varchar(12) NOT NULL,
`sname` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
`cardno` int(10) unsigned NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;--
-- Dumping data for table `student`
--/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` (`sno`,`sname`,`password`,`cardno`) VALUES
('20060101101','张三','123456',1056635538),
('20060101102','李四','123456',101202),
('20060101103','肖波','123456',101203),
('20060101104','王五','123456',101204),
('20060101105','张小二','123456',101205),
('20060101201','曹操','123456',102201),
('20060101202','刘备','123456',102202),
('20060101301','诸葛亮','123456',301201),
('20060101302','赵云','123456',104202);
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
--
-- Definition of table `user`
--DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` varchar(10) NOT NULL,
`username` varchar(45) NOT NULL,
`password` varchar(16) NOT NULL,
`flag` int(10) unsigned NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;--
-- Dumping data for table `user`
--/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`userid`,`username`,`password`,`flag`) VALUES
('000001','食堂消费机一','123456',0),
('000002','食堂消费机二','123456',0),
('000003','食堂消费机三','123456',0),
('001001','admin','123456',1),
('002001','超市一','123456',0),
('002002','超市二','123456',0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2:定位到MYSQL的安装目录的BIN目录下
3:MYSQL -uroot -p rfid<c:\rfidbeifen.sql
先把MYSQLD服务先停了,然后再直接复制数据。
http://hi.baidu.com/fc%EC%E1%D0%A1%B7%E7/album/item/79edd72fa2a6b06b4ec22673.html登陆后:
http://hi.baidu.com/fc%EC%E1%D0%A1%B7%E7/album/item/81276517da64846af2de3273.html麻烦您指点了,感谢~!!!