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

fedora11 Ï mysql Ô´Âë°²×°¹ý³Ì


»·¾³:
  fedora11 , mysql5.1.34Ô´Âë°²×°£º
  
  ×°ÁËÒ»Ìì°ëһֱûÓгɹ¦£¬ºóÀ´·ÅÆúÁË£¬ÒòΪfedora11µÄԴϲ»µ½mysqlËùÒÔÖ»ÄÜ·ÅÆúÔÚfedora11ϵݲװ£¬×ª¶ø¸Äµ½unbuntu9.04Éϰ²×°£¬µ«ÊÇÏëÏëÎÊÌâÊÇûÓÐ
½â¾öµÄ£¬½ñÌìÓÖ×ªÒÆµ½fedoraϸ㣬·¢ÏÖ²»Êǰ²×°mysqlÄÑ£¬ÊÇӦΪ×Ô¼º¶Ôlinuxϵͳ²»ÊìϤ£¬ºÜ¶à¶«Î÷¶¼²»Ã÷°×£¬ËùÒÔûÓÐ×°³É¹¦¡£
  mysqlÔ´Âë°ü°²×°¹ý³Ì²ÉÓÃ./configure make makeinstall
  ÓÉÓÚ°²×°²»ÉÏ£¬ËùÒÔÎÒ²ÉÓÃĬÈÏ·¾¶×°£¬µ£ÐÄÓÖ»á³ö²î´í£¬ÍƼöµÄ°²×°¹ý³ÌÊÇ£º
  $tar xzf mysql-5.1.34.tar.gz¡¾Õâ¸ö¹ý³ÌÊÇÔÚdebianÉϵģ¬ÔÚfedoraºÍubuntu¼°ÆäËülinuxϵͳÉÏÒ²Ò»Ñù¡¿
    $cd mysql-5.1.34/
    $./configure  --enable-local-infile  --with-charset=utf8  --with-extra-charsets=all  --with-plugins=all  --with-big-tables
    $make
    $sudo make install$tar xzf mysql-5.1.34.tar.gz
    $cd mysql-5.1.34/
    $./configure  --enable-local-infile  --with-charset=utf8  --with-extra-charsets=all  --with-plugins=all  --with-big-tables
    $make
    $sudo make install
 µ±°²×°Íê³Éºó£¬½øÈë/usr/local/binÔËÐÐÈçϳÌÐò£º£¨¸Ã³ÌÐòÏÔʾ½á¹ûµÄ˵Ã÷¼ûËùÔÚÐУ©
 [root@localhost bin]# ./mysql_install_db 
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system¡¾×¢ÊÍ£ºÄãÐèÒª½«Ô´Âë°üĿ¼ÏµÄmysql.server¿½±´µ½linuxÆô¶¯Ä¿Â¼Ï£¬¶ÔÓÚfedora11¿½±´µ½µÃĿ¼ÊÇ/etc/init.d/²¢¸ü¸ÄÆäÃû×ÖΪmysqld£¬×¢ÒâÈç¹ûÊǸü¸ÄÁËϵͳĬÈÏ
°²×°Â·¾¶ÐèÒª´ò¿ª¸ÃÎļþ£¬°´ÕÕ¸ÃÎļþÖÐÌáʾµÄÄÚÈÝÐ޸ġ£·ñÔò¿ÉÄܲ»³É¹¦¡£Ö®ºóÐÞ¸ÄȨÏÞ
chmod +x /etc/init.d/mysqld
°²×°½Å±¾ºó£¬ÓÃÀ´¼¤»îËüÒÔ±ãÔÚϵͳÆô¶¯Ê±ÔËÐÐËùÐèÒªµÄÃüÁîÈ¡¾öÓÚÄãµÄ²Ù×÷ϵͳ¡£ÔÚLinuxÖУ¬Äã¿ÉÒÔʹÓÃchkconfig£º
 chkconfig --list mysql
mysql ·þÎñÖ§³Ö chkconfig£¬µ«ËüÔÚÈκμ¶±ðÖж¼Ã»Óб»ÒýÓÃ(ÔËÐГchkconfig --add mysql”)
 chkconfig --a


Ïà¹ØÎĵµ£º

MySQL±íÀàÐͼòµ¥¶Ô±È

MySQLΪÎÒÃÇÌṩÁ˺ܶà±íÀàÐ͹©Ñ¡Ôñ£¬ÓÐMyISAM¡¢ISAM¡¢HEAP¡¢BerkeleyDB¡¢InnoDB£¬MERGE±íÀàÐÍÿһÖÖ±íÀàÐͶ¼ÓÐÆä×Ô¼ºµÄÊôÐÔºÍÓŵ㡣ÏÂÃæÎÒÃÇÀ´¼òµ¥µÄÌÖÂÛһϡ£
MyISAM±íÀàÐÍ£º
MyISAM
±í(TYPE=MYISAM)ÊÇISAMÀàÐ͵ÄÒ»ÖÖÑÓÉ죬¾ßÓкܶàÓÅ»¯ºÍÔöÇ¿µÄÌØÐÔ¡£ÊÇMySQLµÄĬÈϱíÀàÐÍ¡£MyISAMÓÅ»¯ÁËѹËõ±ÈÀýºÍËÙ¶È£¬²¢ÇÒ
¿ÉÒ& ......

MySQLÖ÷´Ó·þÎñÆ÷£¨Replication£©µÄÉèÖÃ

Ê×ÏÈÉèÖÃMySQLÖ÷·þÎñÆ÷£º
ÔÚÖ÷·þÎñÆ÷ÉÏΪ´Ó·þÎñÆ÷½¨Á¢Ò»¸öÓû§£º
grant replication slave on *.* to 'Óû§Ãû'@'Ö÷»ú' identified by 'ÃÜÂë';
Èç¹ûʹÓõÄÊÇMySQL 4.0.2֮ǰµÄ°æ±¾£¬ÔòÓÃfileȨÏÞÀ´´úÌæreplication slave
±à¼­Ö÷·þÎñÆ÷µÄÅäÖÃÎļþ£º/etc/my.cnf
server-id=1
log-bin
binlog-do-db=ÐèÒª¸´ÖƵÄÊý¾Ý¿âÃû£ ......

mysqlÂÒÂëÎÊÌâ

´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎIJåÈëµ½±íÖÐûÓÐÈκÎÎÊÌâ¡£µ«ÊDzåÈëÖÐÎĵÄʱºò¾Í³öÏÖ Data truncation: Data too long for column 'name' at row 1 ÀàËÆµÄÎÊÌâ¡£
mysqlÄܰÑÓ¢ÎÄ×ֶβåÈçÊý¾Ý¿âÁË¡¡µ±ÎÒÊäÈëÖÐÎÄʱËû¾Í³öÏÖ×Ö¶ÎData truncation: Data too long for column 'name' at row 1
ÎÒʹÓÃÅóÓѵÄÕâ¸ö·½·¨£º(1)ÐÞ¸ ......

MySQLÖеÄmysqldumpÃüÁîʹÓÃÏê½â

MySQLÓкܶà¿ÉÒÔµ¼ÈëÊý¾ÝµÄ·½·¨£¬È»¶øÕâЩֻÊÇÊý¾Ý´«ÊäÖеÄÒ»°ë£¬ÁíÍâµÄÒ»°ãÊÇ´ÓMySQLÊý¾Ý¿âÖе¼³öÊý¾Ý¡£ÓÐÐí¶àµÄÔ­ÒòÎÒÃÇÐèÒªµ¼³öÊý¾Ý¡£Ò»¸öÖØÒªµÄÔ­ÒòÊÇÓÃÓÚ±¸·ÝÊý¾Ý¿â¡£Êý¾ÝµÄÔì¼Û³£³£Êǰº¹óµÄ£¬ÐèÒª½÷É÷´¦ÀíËüÃÇ¡£¾­³£µØ±¸·Ý¿ÉÒÔ°ïÖú·ÀÖ¹±¦¹óÊý¾ÝµØ¶ªÊ§£»ÁíÍâÒ»¸öÔ­ÒòÊÇ£¬Ò²ÐíÄúÏ£Íûµ¼³öÊý¾ÝÀ´¹²Ïí¡£ ÔÚÕâ¸öÐÅÏ¢¼¼Êõ²»¶ ......

apache mysql php°²×°

1.apacheµÄ°²×°
apache±¾À´ÊÇÏëÓñàÒë°²×°µÄ£¬µ«ÊÇÆädevelÐèÒªÒÀÀµÒ»Ð©ÆäËûµÄ°ü£¬°²×°ÆðÀ´Ì«Âé·³£¬ËùÒÔ¾ö¶¨Ê¹Óñ¾µØyumÔ´°²×°£»ÔÚrhel5u3ÉÏ£¬Ö±½Ó yum install httpd
     yum install httpd-devel
ÕâÑù»áÓÐhttpd-develµÄһЩÒÀÀµ°üÒ»²¢°²×°ÁË£»
rpm°²×°µÄhttpdÓÐÈçϼ¸¸öÖØÒªµÄĿ¼£º
1)/etc/ht ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ