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

mysql °²×°

½ñÌì°²×°mysqlÓöµ½ºÜ¶àÂé·³£¬ÏëÏóÔ­Òò£¬×Ô¼º»¹ÊÇlinuxµÄ³õѧÕߣ¬Í¬Ê±ÊÜ´ìʱ×ÜÊÇÒª°ÑÎÊÌâµÄ¸´ÔÓϵÊý·Å´ó¡£
1 °²×°³åÍ»
¸ù¾Ý¡¶linux³ÌÐòÉè¼Æ¡·ÉϵÄÖ¸µ¼£¬´Ó¹ÙÍøÏÂÔØÁËmysql-server-xx£¬mysql-devel-xx£¬mysql-client-xx£¬mysql-share-xx£¬È»ºóÖ´ÐÐ
rpm -i *.rpm
½á¹û¶þÊ®¼¸ÐÐconflictÌáʾ£¬ËµÓÐÎļþÓëmysql-server-xxµÄ°²×°³åÍ»¡£ºÃ°É£¬ÏȽâ¾öÈÝÒ׵ģ¬Ë³Àû°²×°ÆäËûÈý¸ö¡£
rpm -qa | grep MySQL
È·ÈÏmysql-server-xxµ¼Ö£¬Ö®ºó
rpm -e MySQL-xx
ÌáʾÒòΪdependence£¬Ö´ÐÐʧ°Ü£¬·¢ÏÖÒÀÀµMySQL-xxµÄÎļþ»¹±»ÒÀÀµ£¬Ò»¸ö¸öÐ¶ÔØÅµ¼ÖÂÌ«¶àÎÊÌ⣬¸É´àÇ¿ÖÆÖ´ÐаÉ
rpm -e --force MySQL-xx
Ö®ºóÔÙÖ´ÐÐÒ»´ÎserverµÄ°²×°£¬³É¹¦À²£¡
2 Á¬½Ó·þÎñÆ÷
Ö´ÐÐÒÔÏÂservice mysql start£¬Á¬½Óʧ°Ü
google·¢ÏÖºÜ¶àµØ·½Ìáµ½/etc/my.cnf£¬¿ÉÊÇÎҵĶÔÓ¦µÄĿ¼ÏÂȴûÓУ¬°´×űðÈ˵ÄÖ¸µã£¬È¥/usr/share/mysqlÏÂÃæcopyÁËÒ»¸ömy-small.cnfµ½/etcÏÂÃæ²¢¸ÄÃûmy.cnf
µ«ÊÇÖ´ÐÐ service mysql start»¹ÊÇʧ°Ü¡£
×îºóÔÚmysql¹ÙÍø·¢ÏÖ£¬ÕâÖÖÇé¿ö¿ÉÄÜÓëSELinuxÏà¹Ø£¬°´×ÅÉÏÃæµÄ²âÊÔ·½·¨£¬
enforce 0
service mysql start
Á¬½Ó³É¹¦ÁË£¬µ½´Ë²ÅÖªµÀÊÇË­ÈǵĻö
È»ºóÎÒ¾ÍÆô¶¯ÁËSELinux manager£¬È»ºó°ÑËü¶ÔmysqlÄ£¿éµÄÏÞÖÆ²ßÂÔÈ«¶¼È¡ÏûÁË£¬ÏÖÔÚÐÄÇ鯽¾²ÁË¡£
ÆäʵÏÖÔÚËäÈ»ÊÇ¿ÉÒÔÅÜÁË£¬µ«ÊǺܶණÎ÷»¹ÊÇûÀí½â£¬ÒÔºóŪ¸ölinux£¬ÂýÂýÃþË÷°É£¡


Ïà¹ØÎĵµ£º

Linux ÏÂMySQL NDBÅäÖÃ

A) Shutdown management node and data node
devmysql3# ndb_mgm -e shutdown
devmysql4# ndb_mgm -e shutdown
B) Shutdown MySQL proccess
devmysql3# mysqladmin shutdown
devmysql4# mysqladmin shutdown
devmysql3 ip: 10.130.30.217
devmysql4 ip: 10.130.30.218
rpm -ivh MySQL-Cluster-gpl-storage ......

php mysql ²ÉÓà utf 8 µÄÅäÖÃ

1¡¢ÔÚÅäÖÃmysqlʵÀýµÄÓïÑÔÑ¡Ïîʱ£¬Ñ¡Ôñutf-8
2¡¢ÔÚhtml,phpÒ³ÃæÖÐ ¼ÓÉÏ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />£¬Èç¹û²»ÐÐÔÙÔÚ phpÎļþ Æðʼ´¦¼Ó header("Content-Type:text/html;charset=utf-8");
3¡¢ÔÚphpÖÐ×öÊý¾Ý¿âÁ¬½Óʱ£¬ÎÒÓõÄʱpdoµÄÐÎʽ£¬Ë ......

linux,nginx,mysql,php°²×°±¸Íü

niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......

MySQLÍêÈ«±¸·Ý¡¢ÔöÁ¿±¸·ÝÓë»Ö¸´

[ ÅäÖÃ ]
Ö´ÐÐÔöÁ¿±¸·ÝµÄǰÌáÌõ¼þÊÇMySQL´ò¿ªlog-binÈÕÖ¾¿ª¹Ø£¬ÀýÈçÔÚmy.ini»òmy.cnfÖмÓÈë log-bin=C:/Program Files/MySQL/MySQL Server 6.0/Data/mysql-bin “log-bin=”ºóµÄ×Ö·û´®ÎªÈÕÖ¾¼ÇÔØÄ¿Â¼£¬Ò»°ã½¨Òé·ÅÔÚ²»Í¬ÓÚmysqlÊý¾ÝĿ¼µÄ´ÅÅÌÉÏ¡£
[ ÍêÈ«±¸·Ý]
¼Ù¶¨ÐÇÆÚÈÕÏÂÎç1µãÖ´ÐÐÍêÈ«±¸·Ý£¬ÊÊÓÃÓÚMyISAM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ