mysql³£¼ûÃüÁî
net start mysql //Æô¶¯mysql·þÎñ
net stop mysql //Í£Ö¹mysql·þÎñ
mysqld-nt --remove //ɾ³ýmysqlºǫ́·þÎñ
mysqld-nt --install //°²×°mysqlºǫ́·þÎñ
mysqld-nt¿ÉÒÔ»»³Émysqld-max-nt»òmysqld
mysql -u root -p
mysql -u root -p mydb <c:\a.sql µ¼ÈëÊý¾Ý
Ïà¹ØÎĵµ£º
1.mysqlµ¼³öÊý¾Ý¿âÃüÁî
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû (±íÃû) > c:\\ÎļþÃû.sql
2.mysqlµ¼ÈëÊý¾Ý¿âÃüÁî
£¨1£©½â¾öÖÐÎÄÂÒÂëÎÊÌ⣺ִÐÐÈçÏÂÃüÁîÔÙµ¼È룺set names utf8
£¨2£©µÇ¼mysql£¬Ö´ÐÐÈçÏÂÃüÁ
mysql> source c:\\ÎļþÃû.sql;
3½â¾öÖÐÎÄÂÒÂëÎÊÌ⣺ִР......
ÐÂÔöÓû§£º
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ÄãµÄÔ¶¶Ëip' IDENTIFIED BY 'ÄãµÄÃÜÂë' WITH GRANT OPTION;
È磺
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.19.220' IDENTIFIED BY '123456' WITH GRANT OPTION;
µÇ¼µ½ÐÂÔöµÄÓû§£º£¨¼ÙÈçÔÊÚȨ»úµÄIPΪ10.10.19.222£©
mysql -uroot -p123456&n ......
1.myisam±í²»Ö§³ÖÍâ¼ü£¬innodb²ÅÖ§³ÖÍâ¼ü
2.mysqlÍâ¼üµÄÁÐÀàÐͺÍÖ÷±íÖÐÏàÓ¦µÄÖ÷¼üÁÐÀàÐͱØÐëÒ»Ö£¬¼´ÀàÐÍÒ»Ö¡¢³¤¶ÈÒ»Ö£¬·ñÔò»á±¨´í¡£ERROR 1005: Can't create table (errno: 150)
3.ÔÚÒ»¸öÊý¾Ý¿âÖÐÍâ¼üÃû×Ö²»ÄÜÖØ¸´£¬·ñÔò»á±¨ERROR 1005: Can't create table 'XXXXXX' (errno: 121) ......
񡜧
CREATE TABLE `user` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(10) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
ÆäÖÐÓÐÊý¾ÝΪ£º
1 name1 123456
2&nbs ......
ʹÓÃmysqlÖеÄwith rollup¿ÉÒԵõ½Ã¿¸ö·Ö×éµÄ»ã×ܼ¶±ðµÄÊý¾Ý£º
±íÈçÏ£º
CREATE TABLE `test3` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name1` varchar(10) DEFAULT NULL,
`name2` varchar(10) DEFAULT NULL,
`cnt` int(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGI ......