Çó¾È¡«ubuntu9.04°²×°mysqlÎÊÌ⣡
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar zxvf mysql-5.1.34.tar.gz
cd mysql-5.1.34/
./configure --prefix=/usr/local/webserver/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase
ÉÏÃæ°²×°Ë³Àû
°²×°µ½ make && make install ³öÒÔÏÂ´í £¨gccÎÒÒѾ°²×°¹ý£©
../depcomp: line 571: exec: g++: δÕÒµ½
make[1]: *** [my_new.o] ´íÎó 127
make[1]:ÕýÔÚÀ뿪Ŀ¼ `/home/testlinux/mysql-5.1.34/mysys'
make: *** [all-recursive] ´íÎó 1
testlinux@ubuntu:~/mysql-5.1.34$ chmod +w /usr/local/webserver/mysql
chmod: ÎÞ·¨·ÃÎÊ"/usr/local/webserver/mysql": ûÓиÃÎļþ»òĿ¼
testlinux@ubuntu:~/mysql-5.1.34$ chown -R mysql:mysql /usr/local/webserver/mysqlchown: ÎÞ·¨·ÃÎÊ"/usr/local/webserver/mysql": ûÓиÃÎļþ»òĿ¼
testlinux@ubuntu:~/mysql-5.1.34$ cd ../
testlinux@ubuntu:~$ mkdir -p /data0/mysql/3306/data/
mkdir: ÎÞ·¨´´½¨Ä¿Â¼"/data0": Permission denied
testlinux@ubuntu:~$ chown -R mysql:mysql /data0/mysql/
chown: ÎÞ·¨·ÃÎÊ"/data0/mysql/": ûÓиÃÎļþ»òĿ¼
Âé·³ÄÇЩ¸ßÊÖ°ï°ïæ ½â¾öÏ£¡ ¸ÐлÁË£¡
g++×°ÁËô?
ÒÔǰװubuntuµÄʱºò,ËÆºõĬÈÏÖ»ÓÐgccÄØ.
Ó¦¸Ã¾Í
Ïà¹ØÎÊ´ð£º
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);
¶¥£¬Ñ§Ï°
SQL code: ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......