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

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶

ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶
ÎÒ°²×°µÄÕâ¸ö°æ±¾µÄMYSQLûÓÐdataÎļþ¼Ð£¬µ«ÊÇ¿ÉÒÔÕý³£Ê¹Ó㬲»ÖªµÀÄãÃǵÄÓÐûÓÐÄØ£¿Ôõô²Å¿ÉÒÔ³öÏÖdataÎļþ¼ÐÄØ£¬Ã»ÓÐ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ÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾­Ñé

½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊDzé±íʱµÄSQLÓï¾ä£©£¬ÎÒÃǶ¼ÐèҪעÒâÊý¾Ý²Ù×÷µÄÐÔÄÜ¡£ÕâÀÎÒÃDz»»á½²¹ý¶àµÄSQLÓï¾äµÄÓÅ»¯£¬¶øÖ»ÊÇÕë ......

²»ÒªÊ¹ÓÃһЩmysqlÌØÓеÄtipÀ´Ð´²éѯ

http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/
ÕâÆªÎÄÕ½¨Ò飺
£¨1£©²»ÒªÊ¹ÓÃһЩmysqlµÄtip£¬È磺SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED£¬STRAIGHT_JOIN£¬³ý·ÇûÓÐÆäËû·½·¨£¬ÒòΪÕâÑùʧȥÁËSQLµÄ¿ÉÒÆÖ²ÐÔ
£¨2£©Êʵ±¶Ô±í½øÐÐË÷Òý
£¨3£©±ÜÃâ¶Ô²»±ØÒªÊý¾ÝµÄ²éѯ
£¨4£©´¦Àí× ......

MYSQL 8Сʱ¶Ï¿ªÁ´½ÓÎÊÌâºÍ½â¾ö°ì·¨

MYSQL 8Сʱ ¶Ï¿ªÁ´½ÓÎÊÌâ
½â¾ö°ì·¨ÓÐÁ½¸ö£ºµÚÒ»ÊÇÉèÖÃautoReconnectÊôÐÔÉèÖÃΪtrue£»µÚ¶þÊÇÉèÖÃDBCP ʱ½«testqueryµÈ¼¸¸öÊôÐÔÒ»²¢ÉèÖá£
ÎÊÌâµÄÔ­ÒòÊÇ£¬MySQLµÄ²ÎÊýinteractive_timeout£¬Ò²¾ÍÊǽ»»¥³¬Ê±Ê±¼äĬÈÏΪ8Сʱ¡£Ò²¾ÍÊÇÈç¹ûÒ»¸öÁ´½ÓÔÚ8Сʱºó£¬»¹Ã»ÓкͷþÎñÆ÷½»»¥£¬Õâ¸öÁ¬½Ó¾Í»á±»MySQL·þÎñÆ÷¶Ï¿ª¡£ÒòΪMySQLÄÜ ......

PHPÁ¬½ÓMYSQLÊý¾Ý¿â

<p>04¼¶ÐÂÉúÃûµ¥</p>
<table border="1" width="80%" cellpadding="0">
<tr>
<td width="10%" align="center">Id</td>
<td width="20%" align="center">Name</td>
<td width="10%" align="center">Age</td>
<td width="10%" align="cent ......

UbuntuÏÂÅäÖÃLAMP£¨Linux+Apache+Mysql+PHP)»·¾³

ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾ­ÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²Å̰²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ