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

mysql´íÎó¼°½â¾öÈ«¹¥ÂÔ

10055:ûÓлº´æ¿Õ¼ä¿ÉÀûÓà  ·½·¨:²é¿´ÏÂÄãµÄCÅÌ¿Õ¼äÊÇ·ñÒѾ­Âú,Çå³ýһЩûÓÐÓõÄÎļþ.   ¿ÉÒÔÔÚºǫ́µÄ"ÂÛ̳ºËÐÄÉèÖÃ","ºËÐŦÄÜÉèÖÃ"Àï"½ø³ÌÓÅ»¯"¿ªÆô,"GZIP ѹËõÊä³ö"¹Ø±Õ. ²éÕÒÁËÒ»ÏÂ10055£¨Ã»Óлº´æ
˵Ã÷:Èç¹ûÓöµ½Êý¾Ý¿â³ö´íµÄÎÊÌâÐÞ¸ÄÏàÓ¦µÄ´úÂëºóÒ»°ãÒªÖØÆômysql¡£Èç¹ûÓöµ½mysqlµÄÎÊÌâ¿ÉÒÔÏÈÖØÆôÒ»ÏÂmysql ¿´¿´ÎÊÌâÄÜ·ñ½â¾ö¡£
1005£º´´½¨±íʧ°Ü
1006£º´´½¨Êý¾Ý¿âʧ°Ü
1007£ºÊý¾Ý¿âÒÑ´æÔÚ£¬´´½¨Êý¾Ý¿âʧ°Ü
1008£ºÊý¾Ý¿â²»´æÔÚ£¬É¾³ýÊý¾Ý¿âʧ°Ü
1009£º²»ÄÜɾ³ýÊý¾Ý¿âÎļþµ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1010£º²»ÄÜɾ³ýÊý¾ÝĿ¼µ¼ÖÂɾ³ýÊý¾Ý¿âʧ°Ü
1011£ºÉ¾³ýÊý¾Ý¿âÎļþʧ°Ü
1012£º²»ÄܶÁȡϵͳ±íÖеļǼ
1016: ÎÞ·¨´ò¿ªÎļþ
   »÷ºó ¿ªÊ¼=>ËùÓгÌÐò=>¸½¼þ=>ÃüÁîÌáʾ·û
   ÊäÈë mysql ËùÔÚÓ²ÅÌÅÌ·û
    cd mysql ËùÔÚĿ¼
    cd bin
   ÊäÈë myisamchk -f D:usr/local/mysql/data/bbs/PW_members.MYI
   ps : D:usr/local/mysql/data/bbs ÊÇÄãÂÛ̳Êý¾Ý¿âµÄ·¾¶
    -f ¸ù¾Ý¾ßÌåÇé¿öÑ¡Ôñ£¬Ò»°ãÒ²¿ÉÒÔÑ¡Ôñ -r
    ×¢ÒâÄãµÄ ϵͳCÅÌ»ò·ÅÊý¾Ý¿âµÄÓ²ÅÌ¿Õ¼äÊÇ·ñ×ã¹»£¬Ò»°ãСÓÚ 1G ºÜÈÝÒ׳öÏÖ´íÎó¡£
   »òÓÃmysqlcheckÃüÁî½øÐÐÐÞ¸´¡£¾ßÌåµÄ·½·¨£ºÀûÓÃÃüÁîÐнøÈëmysql/binĿ¼£¬Ö´ÐÐ
mysqlcheck -o -r phpwind -uroot -p                                                     
 ÆäÖÐphpwindÊÇÄãÊý¾Ý¿âµÄÃû³Æ£¬rootÊÇÄãµÄÊý¾Ý¿âÓû§Ãû£¬È»ºó»áÌáʾÄãÊäÈëÃÜÂë¡£ 
 È»ºó¾Í»áÐÞ¸´ÄãµÄÊý¾Ý¿â¡£
1020£º¼Ç¼Òѱ»ÆäËûÓû§ÐÞ¸Ä
1021£ºÓ²ÅÌÊ£Óà¿Õ¼ä²»×㣬Çë¼Ó´óÓ²ÅÌ¿ÉÓÿռä
1022£º¹Ø¼ü×ÖÖظ´£¬¸ü¸Ä¼Ç¼ʧ°Ü
1023£º¹Ø±Õʱ·¢Éú´íÎó
1024£º¶ÁÎļþ´íÎó
1025£º¸ü¸ÄÃû×Öʱ·¢Éú´íÎó
1026£ºÐ´Îļþ´íÎó
1032£º¼Ç¼²»´æÔÚ
1036£ºÊý¾Ý±íÊÇÖ»¶ÁµÄ£¬²»ÄܶÔËü½øÐÐÐÞ¸Ä
1037£ºÏµÍ³ÄÚ´æ²»×㣬ÇëÖØÆôÊý¾Ý¿â»òÖØÆô·þÎñÆ÷
1038£ºÓÃÓÚÅÅÐòµÄÄÚ´æ²»×㣬ÇëÔö´óÅÅÐò»º³åÇø
1040£ºÒѵ½´ïÊý


Ïà¹ØÎĵµ£º

ͨ¹ýrpm°ü°²×°¡¢ÅäÖü°Ð¶ÔØmysqlµÄÏêϸ¹ý³Ì


¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼Ï 
¡¡¡¡cd /data 
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm 
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf) 
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......

bind+dlz+mysqlʵÏÖÇøÓò¼Ç¼¶¯Ì¬¸üÐÂ


BIND-DLZʵÑé:http://bind-dlz.sourceforge.net/
ʵÑé»·¾³:RHEL4,BIND-9.5.0-P2.tar.gz(9.4.0ÒÔÉÏ°æ±¾¶¼ÒѺ¬DLZ²¹¶¡),Mysql-5.0.56.tar.gz
1¡¢°²×°mysql(ÏÈ°²×°gccµÈÏà¹ØÈí¼þ°ü)
   #tar zxvf mysql-5.0.56.tar.gz 
   #cd mysql-5.0.56
   #./configure --prefix=/usr/local/my ......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
    [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......

mysql ·Ö×é»ã×Ü

 1.´´½¨±í£º
    create table groupTable(dept varchar(6),phone varchar(20),amount int);
 2.²åÈë²âÊÔÊý¾Ý£º
    insert groupTable
    select 'ÓªÒµ²¿',8001,20 union all
    select 'ÓªÒµ²¿',8002,30 union all
    se ......

MySQLѧϰ

×öÈí¼þÊý¾Ý¿â±Ø²»¿ÉÉÙ£¬ÎÒÑ¡ÔñÁËMySQL¡£
Ê×Ïȵ½http://dev.mysql.com/downloads/ÏÂÔغÃMySQL5.1ºÍMySQL GUI TOOLS
ϵ½µçÄÔÉÏ,È»ºó°²×°£¬ÏÈ×°5.1ÔÙ×°gui tools ,һ·ȷ¶¨°É¡£
ŪºÃºó£¬µã¿ªMySQL Query Browser£¬¾Í¿ÉÒÔ²Ù×÷Êý¾Ý¿âÁË¡£
MySQLµÄÇý¶¯³ÌÐòÊÇGUITOOLS°²×°Ä¿Â¼/java/libϵÄmysql-connector-java-5.0.4-bin.ja ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ