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

PHPÔËÐл·¾³ÔÚWindowsϵÄÅäÖÃ(MySQLÅäÖã©

 Èí¼þÀë²»¿ªÊý¾Ý¿â£¬¶øPHP×î³£ÓõÄÊý¾Ý¿âÊÇMySQL¡£MySQLÊý¾Ý¿â·Ö·þÎñ¶ËºÍ¿Í»§¶Ë¡£
MySQL·þÎñ¶ËµÄ°²×°£º
(1)µã»÷MySQL°²×°°ü£¨´Ë´¦µÄ°²×°³ÌÐòΪmysql-5.0.18-win32.zip)
(2) ĬÈÏÊÇTypical,Èç¹ûÏëÐ޸ݲװ·¾¶µÄ»°Ò²¿ÉÒÔÑ¡Ôñcustom.
×¢Òâ:°²×°mysqlµÄ·¾¶ÖÐ,²»Äܺ¬ÓÐÖÐÎÄ!
(3)µã»÷intall¿ªÊ¼°²×°
(4)Ìø¹ý×¢²á
(5)ÊÇ·ñÏÖÔÚ¾ÍÅäÖà MySQL.Ò²¿ÉÒÔÖ®ºóÔÚ¿ªÊ¼²Ëµ¥µÄconfiguration wizard ½øÐÐÅäÖÃ.ÕâÀïÊÇÏÖÔÚ½øÐÐÅäÖÃ
(6)Ñ¡ÔñDetailed Configuration(ÏêϸÉèÖÃ),µãNext¼ÌÐø
(7)ÏÂÃæÕâ¸öÑ¡ÏîÊÇÑ¡ÔñmysqlÓ¦ÓÃÓÚºÎÖÖÀàÐÍ,µÚÒ»ÖÖÊÇ¿ª·¢·þÎñÆ÷,
½«Ö»Óþ¡Á¿ÉÙµÄÄÚ´æ,µÚ¶þÖÖÊÇÆÕͨWEB·þÎñÆ÷,½«Ê¹ÓÃÖеÈÊýÁ¿ÄÚ´æ,
×îºóÒ»ÖÖÊÇÕą̂·þÎñÆ÷ÉÏÃæÖ»ÔËÐÐMySQLÊý¾Ý¿â,½«Õ¼ÓÃÈ«²¿µÄÄÚ´æ.
Óû§¿É¸ù¾Ý×Ô¼ºµÄÐèÇó,Ñ¡ÔñÑ¡Ïî.ÕâÀïֻѡÔñ¿ª·¢·þÎñÆ÷,µãNext¼ÌÐø
(8)ÏÂÃæÊÇÑ¡ÔñÊý¾Ý¿âÓÃ;,µÚÒ»ÖÖÊǶ๦ÄÜÓÃ;,
½«°ÑÊý¾Ý¿âÓÅ»¯³ÉºÜºÃµÄinnodb(ÊÂÎñ)´æ´¢ÀàÐͺ͸ßЧÂʵÄmyisam(·ÇÊÂÎñ)´æ´¢ÀàÐÍ,
µÚ¶þÖÖÊÇÖ»ÓÃÓÚÊÂÎñ´¦ÀíÀàÐÍ,×îºÃµÄÓÅ»¯innodb,µ«Í¬Ê±Ò²Ö§³Ömyisam,Ö»ÓÐmyisam²ÅÖ§³ÖÈ«ÎÄË÷Òý
×îºóÒ»ÖÖÊǼòµ¥µÄÍøÂ翪·¢,ÊʺÏÓÚ¼òµ¥µÄÓ¦ÓÃ,Ö»Óв»Ö§³ÖÊÂÎñµÄmyisamÀàÐÍÊDZ»Ö§³ÖµÄ.
Ò»°ãÑ¡ÔñµÚÒ»Öֶ๦ÄܵÄ.
(9)ÏÂÃæÊÇÑ¡ÔñInnodDBµÄÊý¾Ý´æ·ÅλÖÃ,Ò»°ãĬÈϺÃÁË,²»ÐèÒª¸Ä¶¯(Èç¹ûÒªÐÞ¸ÄÊý¾Ý±£´æ·¾¶,Ò²¿ÉÓÃÔÚ°²×°ºóÐÞ¸Ämy.iniµÄdatadirµÄÖµ)
(10) ÏÂÃæÊÇÑ¡ÔñMySQLÔÊÐíµÄ×î´óÁ¬½ÓÊý,µÚÒ»ÖÖÊÇ×î´ó20¸öÁ¬½Ó²¢·¢Êý,
µÚ¶þÖÖÊÇ×î´ó500¸ö²¢·¢Á¬½ÓÊý,×îºó Ò»ÖÖÊÇ×Ô¶¨Òå,Äã¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐèҪѡÔñ.
ÕâÀïÑ¡ÔñµÚÒ»¸ö
(11)ÏÂÃæÊÇÊÇ·ñÔËÐÐÍøÂçÁ´½Ó.ÕâÀïÑ¡Ôñ¸´Ñ¡¿ò.Êý¾Ý¿â¼àÌýµÄ¶Ë¿Ú,Ò»°ãĬÈÏÊÇ3306,
Èç¹û¸Ä³ÉÆäËû¶Ë¿Ú,ÒÔºóÁ¬½ÓÊý¾Ý¿âµÄʱºò¶¼Òª¼ÇסÐ޸ĵĶ˿Ú,·ñÔò²»ÄÜÁ¬½ÓmysqlÊý¾Ý¿â,
±È½ÏÂé·³,ÕâÀï²»×öÐÞ¸Ä,ÓÃmysqµÄĬÈ϶˿ڣº3306
(12)ÕâÒ»²½ÉèÖÃmysqlµÄĬÈϱàÂë,ĬÈÏÊÇlatin1,Ò²ÊDZê×¼µÄ±àÂë.µÚ¶þÖÖÊÇUTF8,µÚÈýÖÖÊÇÊÖ¶¯ÉèÖÃ.
±àÂëÊÇ°æ±¾4.1ÒÔÉÏÒýÈëµÄ.Èç¹ûÒªÓÃÔ­À´Êý¾Ý¿âµÄÊý¾Ý,×îºÃÄÜÈ·¶¨Ô­À´Êý¾Ý¿âÓõÄÊÇʲô±àÂë,Èç¹ûÕâÀïÉèÖõıàÂëºÍÔ­À´Êý¾Ý¿âÊý¾ÝµÄ±àÂë²»Ò»ÖÂ,ÔÚʹÓõÄʱºò¿ÉÄÜ»á³öÏÖÂÒÂë.½¨ÒéʹÓÃlatin1±ê×¼±àÂë
µ±È»ÎÒÃÇÓÐÐèÒªµÄ»°,Ò²¿ÉÒÔÐÞ¸ÄËüµÄ±àÂë(²»½¨Òé).
(13) ÕâÒ»²½ÊÇÊÇ·ñÒª°ÑmysqlÉèÖóÉwindowsµÄ·þÎñ,Ò»°ãÑ¡ÔñÉè³É·þÎñ,
ÕâÑùÒÔºó¾Í¿ÉÒÔͨ¹ý·þÎñÖÐÆô¶¯ºÍ¹Ø±ÕmysqlÊý¾Ý¿âÁË.ÍƼö£ºÏÂÃæµÄ¸´Ñ¡¿òÒ²¹´Ñ¡ÉÏ,
ÕâÑù,ÔÚcmdģʽÏÂ,²»±Ø·Çµ½mysqlµÄbinĿ¼ÏÂÖ´ÐÐÃ


Ïà¹ØÎĵµ£º

java µ÷ÓÃÃüÁî ±¸·ÝmysqlÊý¾Ý¿â

 ´úÂëÈçÏ£º
  1  String command  =   " cmd /c C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -h localhost -u root -p aijia > E:/aijia.dmp " ;
  2      try    {
  3     Process process& ......

ÈçºÎʹÓÃMySQLÌáÉýȨÏÞ


Ç°²»¾ÃÍøÉϹ«¿ªÁËÒ»¸öMySQL FuncµÄ©¶´,½²µÄÊÇʹÓÃMySQL´´½¨Ò»¸ö×Ô¶¨ÒåµÄº¯Êý,È»ºóͨ¹ýÕâ¸öº¯ÊýÀ´¹¥»÷·þÎñÆ÷¡£×îÔç¿´µ½Ïà¹ØµÄ±¨µÀÊÇÔÚo-otikÉÏ,µ«Êǹ«²¼µÄÊÇÕë¶Ô UnixϵͳµÄExploit,²¢Çҳɹ¦ÂÊÒ²²»ÊǺܸß.¶ø½üÆÚ,¹úÄÚÓиßÊַųöÕë¶ÔWinϵͳµÄÏà¹ØÎÄÕÂ,ÓÚÊÇÎÒÂíÉÏÕÒÀ´ÓëÅóÓÑһͬÑо¿.
ÆäʵÎÒÃÇÔç¾ÍÄÜÏëµ½.µ±ÎÒÃÇÔÚ¶ÔMSSQL ......

ÏêÊöÈçºÎÌá¸ßMySQLÖÐÊý¾Ý×°ÔØЧÂÊ

Õª³­×Ô£ºhttp://database.ctocio.com.cn/153/9232653.shtml
ºÜ¶àʱºò¹ØÐĵÄÊÇÓÅ»¯SELECT ²éѯ£¬ÒòΪËüÃÇÊÇ×î³£ÓõIJéѯ£¬¶øÇÒÈ·¶¨ÔõÑùÓÅ»¯ËüÃDz¢²»×ÜÊÇÖ±½ØÁ˵±¡£Ïà¶ÔÀ´Ëµ£¬½«Êý¾Ý×°ÈëÊý¾Ý¿âÊÇÖ±½ØÁ˵±µÄ¡£È»¶ø£¬Ò²´æÔÚ¿ÉÓÃÀ´¸ÄÉÆÊý¾Ý×°ÔزÙ×÷ЧÂʵIJßÂÔ£¬Æä»ù±¾Ô­ÀíÈçÏ£º
¡¡¡¡³ÉÅú×°Ôؽϵ¥ÐÐ×°Ôظü¿ì£¬ÒòΪÔÚ×°ÔØÿ¸ö¼Ç ......

MySQL±àÂëÎÊÌâ

my.iniÎļþÅäÖ㺠[mysql] default-character-set=GBK #´Ë´¦µÄ±àÂëÊÇMySQL¿ØÖÆ̨ÏÔʾµÄ±àÂ뷽ʽ£¬Ó¦¸ÃÉèÖÃΪGBK [mysqld] default-character-set=utf8 #´Ë´¦µÄ±àÂëÊÇMySQLÊý¾Ý´æ´¢µÄ¸ñʽ£¬Ó¦¸ÃÉèÖÃΪutf8£¬¿ÉÒÔ´æ´¢ÊÀ½çÉϾø´ó¶àÊý×Ö·û ......

MYSQL Íâ¼ü¶¨Òå




½¨Á¢Íâ¼üµÄÇ°Ì᣺ ±¾±íµÄÁбØÐëÓëÍâ¼üÀàÐÍÏàͬ(Íâ¼ü±ØÐëÊÇÍâ±íÖ÷¼ü)¡£
Íâ¼ü×÷Ó㺠ʹÁ½ÕűíÐγɹØÁª£¬Íâ¼üÖ»ÄÜÒýÓÃÍâ±íÖеÄÁеÄÖµ£¡
Ö¸¶¨Ö÷¼ü¹Ø¼ü×Ö£º foreign key(ÁÐÃû)
ÒýÓÃÍâ¼ü¹Ø¼ü×Ö£º references <Íâ¼ü±íÃû>(Íâ¼üÁÐÃû)
ʼþ´¥·¢ÏÞÖÆ: on deleteºÍon update , ¿ÉÉè²ÎÊýcascade(¸úËæÍâ¼ü¸Ä¶¯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ