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

ʹÓÃMySQL Administrator ʵÏÖMySql Êý¾Ý¿â±¸·ÝÓë»Ö¸´


MySQL Administrator ÊÇʲôÈí¼þ£¿
MySQL Administrator ÊÇÒ»¸öרÃÅÓÃÓÚ¹ÜÀí My SQL 4.X ºÍ 5.X My SQLÊý¾Ý¿âµÄÈí¼þ£¬¿ÉÒÔʹÓÃÕâ¸öÈí¼þ±¸·ÝMy SQLÊý¾Ý¿â£¬»¹Ô­My SQLÊý¾Ý¿â¡£
×¢£ºÈç¹ûÄãµÄÊý¾Ý¿âÊÇ MS SQL 2000 Êý¾Ý¿â£¬Çë²Î¿¼ÕâÀʹÓà MS SQL 2000 ÆóÒµ¹ÜÀíÆ÷¹ÜÀí
ÏÂÔØ MySQL Administrator Èí¼þ
http://61.139.76.172/dl/mysql-administrator-1.1.9-win.msi (±¾Õ¾ µçÐÅÕ¾µãÏÂÔØ)
¡¡
http://dev.mysql.com/downloads/administrator/1.1.html (¹Ù·½Õ¾µã Ó¢ÎÄ)
ÇëÑ¡Ôñ Windows downloads Windows (x86)
¡¡
Èç¹ûÄãûÓÐMy SQL 5.x Êý¾Ý¿â£¬Äã¿ÉÒÔÏÈ´ÓÕâÀïÃâ·ÑÉêÇëÒ»¸ö http://www.zcxp.net/sql.asp
ÉêÇë³É¹¦ºó£¬Ä㽫»ñµÃÒÔϲÎÊý£º
Êý¾Ý¿âIP£º61.139.76.107
Êý¾Ý¿âÃû£ºweb3781
Óà »§ Ãû£ºweb
ÃÜ    Â룺£¿£¿£¿£¿£¿
¡¡
Óöµ½ÎÞ·¨µÇ½µÄÇé¿ö£¬ÇëÏÈÔÝʱ¹Ø±Õ±¾µØ¼ÆËã»ú·À»ðǽ£¬Èç ½ðÉ½Íø±ê¡¢ÈðÐÇ¡¢KV2006µÈ
1¡¢´ò¿ªÈí¼þ£¬ÌîдÊý¾Ý¿âIP£¬Óû§ÃûºÍÃÜÂë
2¡¢µÇ½³É¹¦ºó£¬½«³öÏÖÏÂÃæµÄ»­Ãæ
3¡¢²é¿´ÒѾ­´æÔÚµÄÊý¾Ý¿â
Ñ¡Ôñ“Catalogs”½«ÁгöÊý¾Ý¿â
µã×óϽÅÊý¾Ý¿âÁбíÖÐÄ㿪ͨµÄ“Êý¾Ý¿âÃû”£¬±¾Àý×ÓÖÐΪ web37812725£¬Óұ߽«ÏÔʾ³öÊý¾Ý¿âÖÐÒѾ­´æÔÚµÄÊý¾Ý¿â±í£¬Èç¹ûÊÇÐÂÊý¾Ý¿â£¬ÓÒ±ßÊǿյÄ
4¡¢±¸·ÝÊý¾Ý¿âµ½±¾µØ¼ÆËã»úÓ²ÅÌ
½«ÉÏͼËùʾÊý¾Ý¿â“web37812725”±¸·Ýµ½±¾µØ¼ÆËã»úÓ²ÅÌ£¬Ñ¡Ôñ“Backup” ±¸·ÝÊý¾Ý¿â¹¦ÄÜ
µã“New Project” ½¨Á¢Ðµı¸·ÝÏîÄ¿
5¡¢Ñ¡ÔñÒª±¸·ÝµÄÊý¾Ý¿â£¬±¾ÀýÖÐΪ web37812725 Êý¾Ý¿â£¬È»ºóµã > ºÅ
6¡¢Óұ߽«ÏÔʾ³öÊý¾Ý¿â±í½á¹¹
7¡¢±¸·ÝÑ¡Ïî
µã“Advanced Options” ¸ß¼¶Ñ¡Ôñ
Ñ¡Ôñ“Normal backup” ±¸·ÝµÄʱºòÑ¡ÔñÕý³£±¸·Ý
Ñ¡Ôñ“Complete backup” Ñ¡ÔñÍêÕû±¸·Ý
Backup Type ±¸·Ý·½Ê½Ñ¡Ôñ SQL Files
µã“Execute Backup Now”Á¢¿Ì¿ªÊ¼±¸·ÝÊý¾Ý¿â
8¡¢µã“Execute Backup Now”Á¢¿Ì¿ªÊ¼±¸·ÝÊý¾Ý¿â
µã“×ÀÃæ”½«Êý¾Ý¿âÎļþ±£´æµ½×ÀÃæÉÏ£¬·½±ã²éÕÒ
9¡¢±¸·Ý³É¹¦ºó£¬½«³öÏÖÏÂÃæ»­Ãæ
10¡¢´Ó“×ÀÃæ”ÉÏ¿ÉÒÔÕÒµ½¸Õ¸Õ±¸·ÝµÄÊý¾Ý¿â SQL½Å±¾Îļþ£¬¿ÉÒÔÓà Windows ×Ô´øµÄ“¼Çʱ¾”´ò¿ª£¬ÈçÏÂͼËùʾ¡£
11¡¢±¸·ÝÍê³É¡£
=============================================
   ½«±¸·ÝµÄMy SQLÊý¾Ý¿â»¹Ô­µ½Êý¾Ý¿â·þÎñÆ÷
===============


Ïà¹ØÎĵµ£º

Windows Ï Apache Mysql PHP °²×°ºóµÄÅäÖÃ

1 Apache
Ð޸Ġ  documentroot   ¸ùĿ¼
         directory           ·ÃÎʸùĿ¼ȨÏÞ
         directoryindex   Ä¬ÈÏÊ×Ò³ ......

Windows Ï Apache Mysql PHP µÄ°²×°

Ò»  Apache µÄ°²×°
 1  Apache µÄ°²×°
2 ͬÒâЭÒé
3 ½Ó×Å "Next "
4  Ìîд ÓòÃû(network domain) ·þÎñÆ÷µÄÃû³Æ (Server Name) ¹ÜÀíÕßÓÊÏä(Administrator's Email)
5 °²×°ÀàÐÍ
6 Ñ¡Ôñ°²×°Â·¾¶
7 µã»÷“install ” ¼ÌÐø
8 ¿ªÊ¼°²×°
9  °²×°½áÊø
¶þ   MySqlµÄ°²×° ......

MySQLÒýÇæ

¡¡MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ÒâµÄ»°£¬ÄãÉõÖÁ¿ÉÒÔʹÓÃMySQL++ APIÀ´´´½¨×Ô¼ºµÄÊý¾Ý¿âÒýÇæ£¬¾ÍÏñ´ò´©Æø¸××°ÉÏ×Ô¼ºµÄ»¯ÓÍÆ÷¡£ÏÖÔÚÈÃÎÒÃÇÀ´¿´¿´Äã¸ÃÈçºÎÑ¡ÔñÒýÇæ£¬ÒÔ¼°ÈçºÎÔÚ¿ÉÓÃÒýÇæÖ®¼äÇл»¡£
¡¡¡¡
¡¡¡¡Ñ¡ÔñÄãµÄÒýÇæ
¡¡¡¡
¡¡¡¡ÄãÄÜÓõÄÊý¾Ý¿ ......

MySQL ÃüÁîÐÐ ÖÐÎÄÂÒÂë

Óöµ½Ò»¸öÎÊÌâÊÇÔÚMySQLÃüÁîÐвåÈëÖÐÎÄÊý¾Ý»òÕß²éѯÖÐÎÄÊý¾Ýʱ³öÏÖÂÒÂ룬»òÕßÏÔʾ²»¶Ô¡£
 
ÔÚÃüÁîÐÐÊäÈë:show variables like ‘character_set_%’;
 
²é¿´µ±Ç°ÅäÖõıàÂ룻
 
 
ÔÚÃüÁîÐÐÊäÈë :set names utf8;
ÔòµÈͬÓÚ
set character_set_client=utf8;
set character_set_results ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ