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-noinstall-5.1.6(win32)ΪÀý
1>°ÑѹËõÎļþmysql-noinstall-5.1.6-alpha-win32.zip½âѹµ½Ò»¸öĿ¼Ï£¬ÔÚ»·¾³±äÁ¿ÖÐÉèÖÃMYSQL_HOME£¬°Ñ%MYSQL_HOME%\bin ¼Ó
Èëµ½ path¡£
2>´´½¨my.iniÅäÖÃÎļþ,ÄÚÈÝÈçÏ£º
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=...\mysql
datadir=...\mysql\data
my.iniÎ ......
MYSQL°²×°
//½âѹ±àÒë°²×°
# tar xzvf mysql-5.0.27.tar.gz
# cd mysql-5.0.27
# ./configure -prefix=/home/redadmin/mysql
# make
# make install
# cd /home/redadmin/mysql/
# cp share/mysql/my-medium.cnf ./
# mv my-medium.cnf my.cnf
// my.confÎļþÐÞ¸Ä
# vi my.cnf
ÐÞ¸ÄÇ°£º
port &nb ......
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
sudo apt-get install mysql-server mysql-admin mysql-navigator mysql-query-browser
Õâ¸öÓ¦¸ÃºÜ¼òµ¥ÁË£¬¶øÇÒÎÒ¾õµÃ´ó¼ÒÔÚ°²×°·½ÃæҲûʲô̫´óÎÊÌ⣬ËùÒÔÒ²¾Í²»¶à˵ÁË£¬ÏÂÃæÎÒÃÇÀ´½²½²ÅäÖá£
ÅäÖÃMySQL
×¢Ò⣬ÔÚUbuntuÏÂMySQLȱʡÊÇÖ»ÔÊÐí±¾µØ·ÃÎʵģ¬Èç¹ûÄãÒªÆäËû»úÆ÷Ò²Äܹ»·ÃÎʵĻ°£¬ÄÇôÐèÒª¸Ä±ä/etc/m ......