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

Linux ƽ̨Ï MYSQL°²×° Æô¶¯ mysqlÃüÁî

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            = 3306
socket          = /tmp/mysql.sock
Ð޸ĺó£º
port            = 3307
socket          = /tmp/mysql5.sock
// mysqlÊý¾Ý¿â³õʼ»¯
# ./mysql_install_db --defaults-file=../my.cnf --user=mysql
// mysqlÆô¶¯
# ./mysqld_safe --defaults-file=../my.cnf --user=mysql &
// mysqlÃüÁî
# ./mysql --defaults-file=../my.cnf
# create database pligg
select * from user;
quit;
./mysqladmin --port=3307 --socket=/tmp/mysql5.sock -u root -p shutdown
mySqlֹͣ
/home/redadmin/mysql/bin/mysqladmin  --port=3307 --socket=/tmp/mysql5.sock -u root -p shutdown
MYSQL°²×°£¨½âѹ°æ£©
# gunzip mysql-5.0.51a-solaris10-i386.tar.gz
# tar xvf mysql-5.0.51a-solaris10-i386.tar
# cp mysql-5.0.51a-solaris10-i386/* /usr/local/mysql/
# cd /usr/local/mysql/
# chown -R mysql .
# chgrp -R mysql .
// mysqlÊý¾Ý¿â³õʼ»¯
# cp ./support-files/my-medium.cnf ./my.cnf
# scripts/mysql_install_db --user=mysql
// mysqlÆô¶¯
# chown -R root .
# chown -R mysql data
# bin/mysqld_safe --user=mysql &
// mysqlÃüÁî
# ./mysql -u root -p
mysql>  create database deva_db


Ïà¹ØÎĵµ£º

MySql³£ÓÃÃüÁî

MySQL³£ÓòÙ×÷»ù±¾²Ù×÷£¬ÒÔ϶¼ÊÇMySQL5.0ϲâÊÔͨ¹ýÊ×ÏÈ˵Ã÷Ï£¬¼ÇסÔÚÿ¸öÃüÁî½áÊøÊ±¼ÓÉÏ£»£¨·ÖºÅ£©
1.µ¼³öÕû¸öÊý¾Ý¿â
mysqldump -u Óû§Ãû -p --default-character-set=latin1 Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû(Êý¾Ý¿âĬÈϱàÂëÊÇlatin1)
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Ó ......

Mysql innodb Îóɾ³ýÊý¾Ý¿âÊÇ·ñ¿É»Ö¸´

¿ÉÒÔ£¬µ«ÊÇÍêÈ«»Ö¸´ËùÓÐµÄ±í²»Ò»¶¨¿ÉÒÔ
¹¤¾ß: innodb-recovery
Official Website: http://code.google.com/p/innodb-tools/
This set of tools could be used to check InnoDB
tablespaces and to recover data from damaged tablespaces or from
dropped/truncated InnoDB tables.
Õâ¸ö¹¤¾ßÓÃÀ´¼ì²éInnoDB¿Õ¼ä±íºÍ» ......

mysqlÓÅ»¯£º ÄÚ´æ±íºÍÁÙʱ±í


mysqlÓÅ»¯£º ÄÚ´æ±íºÍÁÙʱ±í
2009Äê02ÔÂ01ÈÕ ÐÇÆÚÈÕ 10:41
ÓÉÓÚÖ±½ÓʹÓÃÁÙʱ±íÀ´´´½¨Öмä±í£¬ÆäËٶȲ»ÈçÈËÒ⣬Òò¶ø¾ÍÓÐÁ˰ÑÁÙʱ±í½¨³ÉÄÚ´æ±íµÄÏë·¨¡£µ«ÄÚ´æ±íºÍÁÙʱ±íµÄÇø±ðÇÒ²¢²»ÊìϤ£¬ÐèÒª²éÕÒ×ÊÁÏÁË¡£
Ò»¿ªÊ¼ÒÔΪÁÙʱ±íÊÇ´´½¨ºó´æÔÚ£¬µ±Á¬½Ó¶Ï¿ªÊ±ÁÙʱ±í¾Í»á±»É¾³ý£¬¼´ÁÙʱ±íÊÇ´æÔÚÓÚ´ÅÅÌÉϵġ£¶øÊµ¼Ê²Ù×÷Öз¢ÏÖÁÙÊ ......

CentOS ÉÏmysql¶Ë¿Ú3306µÄÎÊÌâ

½ñÌì×°ÁËһ̨Linuxϵͳ£¬ÒÔǰ¶¼ÊÇRedHat£¬ºóÀ´Ìý˵ÓÐFedoraÁË£¬Ò»Ö±Ã»Óùý¡£ÕýºÃÏîÄ¿Àï»·¾³ÒªÓþÍÏëŪһ¸öÀ´ÍæÍ棬½á¹ûÏÖÔÚÈ˼Ò×îеÄÊÇCentOS£¬¾ÍÒ»ÕÅCD£¬ÆäËûµÄ¸ù¾ÝÐèÒª×Ô¼ºÉÏÍøDown£¬£¨ÎÒ²»Ï²»¶ÕâÑù×Ó¾Í×Ô¼ºÏÂÔØDVD°æ£©¡£°²×°ÍêÖ®ºóûÓÐͼÐνçÃæ£¬¶øÇÒûÓÐÌáʾÊäÈërootÃÜÂ룬»¹µÃµ½µ¥Óû§Ä£Ê½ÏÂÐ޸ġ£ºóÀ´ÏÂÔØÁËÒ»¸öͼÐÎ ......

Ubuntu 9.04 ÏÂMySQLÖÐÎÄÂÒÂëµÄ½â¾ö

        Ubuntu 9.04 ÏÂÓÃÔ´°²×°ÁËMySQL¡£Ä¬ÈÏÇé¿öÏ£¬ÓÃmysql shellµÇ¼´´½¨Êý¾Ý¿â´´½¨±í²åÈëÖÐÎÄÊý¾Ýºó£¬ÓÃselect²é³öÀ´ÊÇÖÐÎÄ£¬µ«ÓÃJDBCÁ¬½Ó¾Í³öÏÖÂÒÂë¡£ÍøÉÏËÑË÷µ½½â¾ö·½·¨£¬ÈçÏ£¨Ïȱ¸·ÝÊý¾Ý£©£º
ÐÞ¸Ä/etc/mysql/my.cnf
sudo gedit /etc/mysql/my.cnf
ÔÚmy.cnfÎļþÖеÄ[client] ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ