ʹÓÃ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Êý¾Ý¿â»¹Ôµ½Êý¾Ý¿â·þÎñÆ÷
===============
Ïà¹ØÎĵµ£º
1 Apache
ÐÞ¸Ä documentroot ¸ùĿ¼
directory ·ÃÎʸùĿ¼ȨÏÞ
directoryindex ĬÈÏÊ×Ò³ ......
MySQL²éѯ±íÄÚÖظ´¼Ç¼
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΠ......
½â¾öThe‘InnoDB’feature is disabled; you need MySQL built with ‘InnoDB’ to have it2009Äê12ÔÂ29ÈÕ ÐÇÆÚ¶þ ÉÏÎç 11:15MySQL
³öÏÖÈçÏÂÓï¾ä£ºThe ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working£»
ÊÇmysqlÅäÖÃÎļþ½ûµôÁËÕâ¸öÑ¡ ......
½ñÌìÖÕÓÚÕÒµ½×Ô¼ºµ÷ÊÔÉÐѧÌÃshoppingÏîĿʱµÄÎÊÌâËùÔÚÁË£¬Í¨¹ý²é×ÊÁÏ£¬¶ÔmyeclipseºÍtomcatµÄ²¿ÊðÓÖÓÐÁ˸üÉîÒ»¸ö²ã´ÎµÄÁ˽⣬³ÌÐòµ÷ͨÁË£¬ÐË·ÜÁËÒ»ÏÂÏ£¬¹þ¹þ¡£¡£
È¥ºǫ́Ìí¼ÓÊý¾Ý·¢ÏÖ´ÓmysqlÖжÁ³öµÄÖÐÎÄÈ«²¿ÏÖʵΪ¿É°®µÄÎʺţ¬ÕâϺÃÁË£¬ÎÒÐÄÀïÒ²²úÉúÎʺŠ......
ÕâÁ½ÌìÕýÔÚ²âMYSQLµÄÐÔÄÜ£¬°´ÕÕMYSQLÎĵµÖÐÍƼöµÄÉèÖã¬ÐÞ¸ÄÁ˼¸¸öϵͳ±äÁ¿
innodb_buffer_pool_size=1G
innodb_log_file_size=250M
innodb_log_buffer_size=8M
½á¹ûMYSQL±ÀÁË¡£mysql¿Í»§¶ËÄܵǼ£¬µ«Ö»ÒªÖ´ÐÐÈκÎÃüÁmysqldÁ¢¿Ì±Àµô¡£
¿ªÊ¼»¹ÒÔΪÊÇinnodb_buffer_pool_sizeµÈ¼¸¸ö²ÎÊýÉèµÃÌ«´óÁË£¬¿ÉÊǵ÷ÕûÁ˼¸´Î¶ ......