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

mysql±¸·Ý»Ö¸´

Òª備·Ý MySQL 資ÁÏ庫Ö÷Òª·Ö為兩個·½·¨£¬Ò»ÊÇ將資ÁÏ庫Ä¿錄ÍêÕû備·Ý£º¶þÊÇʹÓà MySQL 內½¨µÄ mysqldump ³Ìʽ¡£
備·Ý資ÁÏ庫Ä¿錄
MySQL 預設µÄ儲´æÄ¿錄ÔÚ /var/lib/mysql 內ÈÝ£¬µ×ÏÂ會ÓÐÒÔ資ÁÏ庫Ãû稱µÄÄ¿錄£¬ÀýÈç mydb
Ä¿錄±ã應該ÊÇ mydb 資ÁÏ庫µÄ資ÁÏ¡£
Èç¹û MySQL ÕýÔÚ運ÐУ¬請ÏÈÍ£Ö¹ MySQL£¬Ô­ÒòÊÇ¿ÉÄÜ會ÓÐ資ÁÏδÍêÈ«寫È룬¶ø MySQL 會 lock ÔÚʹÓÃÖÐµÄ DB 檔°¸¡£
01
/etc/rc.d/init.d/mysqld stop
02
cd /var/lib/mysql/
03
tar zxcf mydb_backup.tgz mydb
04
/etc/rc.d/init.d/mysqld start
ÒÔÉÏÖ¸Áî會ÏÈÍ£Ö¹ MySQL£¬È»áá°Ñ mydb 資ÁÏ庫製×÷Ò»個 taz 檔µÄ備·Ý£¬並儲´æµ½ mydb_backup.tgz¡£
ÔÚʹÓÃÒÔÉÏÖ¸Áî時£¬請¸ù據個別ϵ統µÄ設¶¨×÷³öÐ޸ġ£
ºÃÁË£¬ÒÔÉϾÍ麼 3 ¾äÖ¸Áî¾ÍÍê³É備·ÝÁË£¬Èç¹û²»ÐÒµÄÊÂÇé發ÉúÁË£¬資ÁÏ庫發Éú錯誤¶øÒª復Ô­資ÁÏ£¬¿ÉʹÓÃÒÔÏÂÖ¸Á
01
/etc/rc.d/init.d/mysqld stop
02
cd /var/lib/mysql/
03
mv mydb mydb_error
04
tar zxvf mydb_backup.tgz
05
/etc/rc.d/init.d/mysqld start
ÒÔÉÏÖ¸ÁîÊÇÏ顄 /var/lib/mysql/mydb ÒÆµ½ /var/lib/mysql/mydb_error£¬È»áá將Ô­ÏÈ製×÷µÄ備·Ý檔½â壓µ½
/var/lib/mysql/mydb¡£
Òª備·Ý MySQL 資ÁÏ庫Ö÷Òª·Ö為兩個·½·¨£¬Ò»ÊÇ將資ÁÏ庫Ä¿錄ÍêÕû備·Ý£º¶þÊÇʹÓà MySQL 內½¨µÄ mysqldump ³Ìʽ¡£
備·Ý資ÁÏ庫Ä¿錄
MySQL 預設µÄ儲´æÄ¿錄ÔÚ /var/lib/mysql 內ÈÝ£¬µ×ÏÂ會ÓÐÒÔ資ÁÏ庫Ãû稱µÄÄ¿錄£¬ÀýÈç mydb
Ä¿錄±ã應該ÊÇ mydb 資ÁÏ庫µÄ資ÁÏ¡£
Èç¹û MySQL ÕýÔÚ運ÐУ¬請ÏÈÍ£Ö¹ MySQL£¬Ô­ÒòÊÇ¿ÉÄÜ會ÓÐ資ÁÏδÍêÈ«ë


Ïà¹ØÎĵµ£º

MySQL Cluster Multi Computer Configuration


For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.

Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......

Safe Shutdown and Restart of MySQL Cluster


To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:

shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......

MysqlµÄGROUP_CONCAT()º¯ÊýʹÓ÷½·¨ ¶àÐкϲ¢º¯Êý

GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......

Ö§³ÖMySqlÒ»°Ñ

ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£

ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡


´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......

mysqlÊý¾Ý¿âº¯Êý

²éѯÓï¾ä:
SELECT ×Ö¶ÎÃû from ±íÃû.
ÅÅÐò order by ÒªÅÅÐòµÄ×Ö¶ÎÃû desc :ÒÔµ¹Ðò²éѯ.
limit ´ÓµÚ¼¸¸ö¿ªÊ¼ ²éÕÒ¶àÉÙ¸ö :²éÕÒÖ¸¶¨¸öÊý.
ͬʱ²éѯ¶à¸ö×Ö¶ÎÓÃ","¸ô¿ª.
Èç²éѯ±íÀïÃæµÄËùÓÐÊý¾ÝÔÚ×Ö¶ÎÃû´¦Ìî"*".
ÈçÖ»ÏëÏÔʾij×ֶεÄǰ¼¸Î»×Ö·û¿ÉÒÔʹÓÃLEFTº¯Êý.
SELECT ×Ö¶ÎÃû,LEFT(×Ö¶ÎÃû,λÊý),×Ö¶ÎÃû from ±íÃû.
COU ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ