ãã1.åæ¢æ°æ®åºæå¡ï¼
ãã使ç¨/etc/init.d/mysql stop æè
stop mysql
ãã2. å¨ç®æ ä½ç½®ï¼/data)å建æ°æ®åºæ件çç®å½(å¦/mysqldb)ï¼å¹¶å¤å¶ï¼å¦æä¸å使ç¨é»è®¤çä½ç½®ï¼åå¯ä»¥ç´æ¥mvåå
æ°æ®åºæ件å°æ°ç®å½ä¸ï¼åå
çæ°æ®åºæ件ç®å½å°è¯¥ç®å½ä¸ï¼
ããcd /data
ããmkdir mysqldb
ããcp -r /var/lib/mysql /data/mysqldb/
ããç»è¿ä¸æ®µæ¶é´ççå¾
åï¼å¨/data/mysqldb/ä¸é¢å°±æäºåå
é»è®¤çmysqlæ°æ®åºæ件ç®å½çæ·è´â/mysqlâ
ãã
ãã3.ä¿®æ¹my.cnfæ件
ãã# vim /etc/mysql/my.cnf
ããå°datadir = /var/lib/mysql æ¹ä¸º datadir = /data/mysqldb/mysql
ããå¦å¤ç±äºå½åmy.cnf ä¸çsocket = /var/run/mysqld/mysqld.sockï¼è并éåç½ä¸æ说çsock = /var/lib/mysql/mysql.sockï¼ï¼å³socketçä½ç½®å¹¶ä¸å¨æ°æ®åºæ件æå¨çä½ç½®ï¼å æ¤å¯ä»¥ä¸å类似ç½ä¸å
¶ä»ç½é¡µæ说çï¼è¦ä½¿ç¨ä»¥ä¸çå½ä»¤åä¸ä¸ªmysql.sock é¾æ¥ï¼
ããln -s /data/mysqldb/mysql/mysql.sock /var/lib/mysql/mysql.sock (éè¦ä»/home/data/mysqlä¸å¤å¶ä¸ä»½è¿æ¥)
ãã4. ä¿®æ¹æ°æ®åºçæéï¼
ãã# chown -R mysql:mysql /data/mysqldb/mysql/ã â æ¹åæ°æ®åºæ件ç®å½çå½å±ä¸ºmysql
ãã# chmod 700 /data/mysqldb/mysql/whois/ã â æ¹åæ°æ®åºç®å½whoisçå±æ§ä¸º700
ãã# chmod 660 /data/mysqldb/mysql/whois/*ã â æ¹åæ°æ®åºä¸æ°æ®è¡¨çå±æ§ä¸º660
ã
ãã5. ä¿®æ¹æ件usr.sbin.mysqld
ãã# vim /etc/apparmor.d/usr.sbin.mysqld
ããæ
ãã/var/lib/mysql r,
ãã/var/lib/mysql/** rwk,
ãã
ããæ¹æ
ãã/data/mysqldb/mysql/ r,
ãã/data/mysqldb/mysql/** rwk,
ãã注æï¼æ²¡æ该æ¥éª¤çè¯ï¼å°å¯¼è´æ°æ®åºæå¡æ æ³éå¯ï¼å¥½åå¨éå¯ï¼ä½æ¯ä¸ç´å¡ä½æ ååºã
ãã
ãã6.å¯å¨mysqlæå¡å¨
ãã/etc/init.d/apparmor restartãã
ãã/etc/init.d/mysql restart ï¼æè
ä½¿ç¨ restart mysqlï¼
温馨提示:答案为网友推荐,仅供参考