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£ºÒѵ½´ïÊý
Ïà¹ØÎĵµ£º
¡¡¡¡ÒÔ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ʵÑé: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 ......
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 ......
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¡£
Ê×Ïȵ½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 ......