Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ûÓÐdataĿ¼µÄ½â¾ö·½°¸

¿ÉÒԲ鿴mysqlÎļþĿ¼my.iniÎļþ£¬¿ÉÒÔÕÒµ½ÀàËÆÓÚ
datadir="D:/beeagle/Program Files/MySQL/MySQL Server 5.0/Data/"µÄ×Ö¶Î
¸Ã·¾¶Îªmysql dataĿ¼
ĬÈÏÔÚ£º"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data\"
×¢Ò⣺Application DataÎļþ¼ÐÊÇÒþ²ØµÄ£¡£¡£¡
¿ÉÒÔÐÞ¸ÄÉÏÊöÅäÖ㬰ÑDataÎļþ¼Ð·ÅÔÚÄãÏë·ÅµÄµØ·½¡£
---Ð޸ķ½Ê½ÈçÏ£º
1.Í£Ö¹mysql£¬ÔÚÃüÁî´°¿ÚÖÐÊäÈë²¢ÔËÐУºnet stop mysql ¼´¿É£»
2.°Ñ"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data\" ÀïµÄDataÎļþ¼Ð¼ôÇе½Ä¿µÄµØ¡£±¾È˰ÑËü·Åµ½ÁË"D:\PHP\MySQL\MySQL Server 5.1"Ŀ¼Ï£¨¸úmysql·Åµ½ÁËÒ»Æð£©£¬²¢ÇÒ°ÑĿ¼"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\"ɾ³ýµô¡£
3.ÐÞ¸Ämy.iniÎļþ£¬°Ñdatadir¸Ä³É datadir="D:\PHP\MySQL\MySQL Server 5.1\data\"
4.Æô¶¯mysql,ÔÚÃüÁî´°¿ÚÖÐÊäÈë²¢ÔËÐУºnet start mysql ¼´¿É£»
5.ÐÞ¸ÄÍê±Ï£¬ÒÔºó¾Í¿ÉÒÔ°ÑÏàÓ¦µÄÊý¾Ý¿â¸½¼Ó¶ÔÏó¿½±´µ½ÀïÃæÀ´¡£


Ïà¹ØÎĵµ£º

½â¾ömysql¡°Access denied for user

½â¾ömysql“Access denied for user
ÎÒµÄϵͳÊÇubuntu6.06£¬×î½üÐÂ×°ºÃµÄmysqlÔÚ½øÈëmysql¹¤¾ßʱ£¬×ÜÊÇÓдíÎóÌáʾ:
# mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ʹÓÃÍøÉϽéÉܵķ½·¨ÐÞ¸ÄrootÓû§µÄÃÜÂ룺
# mysqladmin -uroot -p p ......

Ò»¸ö¼òµ¥µÄASP.NET·ÃÎÊMySqlÊý¾Ý¿â

ÏÂÔØ ADO.NET Driver for MySQLMySql.Data.dll
°²×°ºó£¬ÔÚ°²×°Ä¿Â¼ÏÂÃæÕÒµ½Assemblies
Îļþ¼Ð£¬ÕÒµ½ MySql.Data.dll
(´ËÎļþÊÇ.Net·ÃÎÊMySQLÊý¾Ý¿âµÄÒ»¸öÇý¶¯£¬ÍêÈ«ADO.NETÊý¾Ý·ÃÎÊģʽ£¬ÓÉMySQL¹Ù·½Ìṩ£¬Óжà¸ö°æ±¾¿ÉÑ¡Ôñ¡£)
 Ñ§Ï°µÄÒ»¸öÁ´½Ó£ºhttp://www.cnblogs.com/wcfgroup/articles/1242256.html
´´½¨Ò»¸ö ......

MySQLÐÔÄÜÓÅ»¯

1. ¼ò½é

ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ²úÆ·ÖÐʹÓÃMySQLÊý¾Ý¿â±ØÐë½øÐбØÒªµÄÓÅ»¯¡£
ÓÅ»¯ÊÇÒ»¸ö¸´ÔÓµÄÈÎÎñ£¬±¾ÎÄÃèÊöMySQLÏ ......

MySQL 5.1 °²×°ÅäÖÃͼ½â


Ò»¡¢MySQL5.1°²×°
       ´ò¿ªÏÂÔØµÄ°²×°Îļþ£¬³öÏÖÈçϽçÃæ£º
 
mysql°²×°Ïòµ¼Æô¶¯£¬µã»÷“next”¼ÌÐø
 
        Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶ ......

mySQL Êý¾ÝµÄµ¼Èëµ¼³ö

¼¸¸ö³£ÓÃÓÃÀý£º
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
mysqldump ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ