Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬Ô­ÒòÊÇ¿ÉÄÜ會ÓÐ資ÁÏδÍêÈ«ë


Ïà¹ØÎĵµ£º

Initial Startup of MySQL Cluster


Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......

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])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......

linuxϵ¼Èë¡¢µ¼³ömysqlÊý¾Ý¿âÃüÁî

Ò»¡¢µ¼³öÊý¾Ý¿âÓÃmysqldumpÃüÁעÒâmysqlµÄ°²×°Â·¾¶£¬¼´´ËÃüÁîµÄ·¾¶£©£º
1¡¢µ¼³öÊý¾ÝºÍ±í½á¹¹£º
mysqldump -uÓû§Ãû -p Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
#/usr/local/mysql/bin/mysqldump -uroot -p abc > abc.sql
Çûسµºó»áÌáʾÊäÈëÃÜÂë
2¡¢Ö»µ¼³ö±í½á¹¹
mysqldump -uÓû§Ãû -p -d Êý¾Ý¿âÃû > Êý¾Ý¿âÃû.sql
# ......

Ö§³Ö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ºÅ