Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ϵͳ±äÁ¿interactive_timeout Óë wait_timeout

http://blog.chinaunix.net/u/14014/showart_490462.html
mysql>show variables like '%timeout';
´òÓ¡½á¹ûÈçÏ£º
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| connect_timeout | 5 |
| delayed_insert_timeout | 300 |
| interactive_ ......

ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨

×÷Õß: Ф½¨±ò
| ¿ÉÒÔ×ªÔØ, ×ªÔØÊ±Îñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂԭʼ³ö´¦
ºÍ×÷ÕßÐÅÏ¢¼°°æÈ¨ÉùÃ÷
꿅᣼http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql×´ ......

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


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

mysqlµÄÈȱ¸£º mysql replicationÔ­Àí½éÉÜ

×î½üÒµÎñ·ÃÎÊÁ¿±È½Ï´ó£¬Êý¾Ýͳ¼ÆÀàµÄ²Ù×÷¶¼Çл»µ½mysqlµÄ±¸»úÉÏÈ¥ÁË£¬±¸»úµÄ¶Á²Ù×÷²»»áÓ°ÏìÖ÷¡¢±¸Ö®¼äµÄÈȱ¸µÄ
ÏÂÃæÁÐһϾßÌåµÄÔ­Àí£º
ÒªÏëÓúÃÒ»¸öϵͳ£¬Àí½âÆäʵÏÖÔ­ÀíÊǷdz£ÖØÒªµÄÊÂÇ飬ֻÓÐÀí½âÁËÆäʵÏÖÔ­Àí£¬ÎÒÃDzÅÄܹ»Ñﳤ±Ü¶Ì£¬ºÏÀíµÄÀûÓ㬲ÅÄܹ»´î½¨³ö×îÊʺÏÎÒÃÇ×Ô¼ºÓ¦Óû·¾³µÄϵͳ£¬²ÅÄܹ»ÔÚϵͳʵʩ֮ºó¸üºÃµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ