MySQL 有關資料庫路徑的設定放在何處 - Linux
By Faithe
at 2010-02-26T17:06
at 2010-02-26T17:06
Table of Contents
※ 引述《iso9660 (iso9660)》之銘言:
: 請參考一下這篇
: Ubuntu 移動 MySQL datadir
: http://kadok0520.pixnet.net/blog/post/25349345
我參考上面的文件,試著移動 mysql 的資料庫,
1. sudo cp -a /var/lib/mysql /var/lib/mysqlTTT
2. sudo vi /etc/apparmor.d/usr.sbin.mysqld
把以下的內容
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
改成
/var/lib/mysqlTTT/ r,
/var/lib/mysqlTTT/** rwk,
3. sudo vi /etc/mysql/my.cnf
把 datadir = /var/lib/mysql 換成 datadir = /var/lib/mysqlTTT,
4. sudo /etc/init.d/apparmor restart
sudo /etc/init.d/mysql restart
可是 mysql 卻是無法啟動,
其錯誤訊息是
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
即使是我把步驟 1 改成
1a. sudo cp -a /var/lib/mysql /var/lib/mysqlTTT
1b. sudo chown -R mysql:mysql /var/lib/mysqlTTT
也是無效,
請問我是不是有什麼地方弄錯了呢?我應該如何進行才對,謝謝
--
: 請參考一下這篇
: Ubuntu 移動 MySQL datadir
: http://kadok0520.pixnet.net/blog/post/25349345
我參考上面的文件,試著移動 mysql 的資料庫,
1. sudo cp -a /var/lib/mysql /var/lib/mysqlTTT
2. sudo vi /etc/apparmor.d/usr.sbin.mysqld
把以下的內容
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
改成
/var/lib/mysqlTTT/ r,
/var/lib/mysqlTTT/** rwk,
3. sudo vi /etc/mysql/my.cnf
把 datadir = /var/lib/mysql 換成 datadir = /var/lib/mysqlTTT,
4. sudo /etc/init.d/apparmor restart
sudo /etc/init.d/mysql restart
可是 mysql 卻是無法啟動,
其錯誤訊息是
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
即使是我把步驟 1 改成
1a. sudo cp -a /var/lib/mysql /var/lib/mysqlTTT
1b. sudo chown -R mysql:mysql /var/lib/mysqlTTT
也是無效,
請問我是不是有什麼地方弄錯了呢?我應該如何進行才對,謝謝
--
Tags:
Linux
All Comments
By Yuri
at 2010-02-27T02:47
at 2010-02-27T02:47
By Joseph
at 2010-02-27T21:15
at 2010-02-27T21:15
By Megan
at 2010-03-03T22:17
at 2010-03-03T22:17
By Emily
at 2010-03-05T20:46
at 2010-03-05T20:46
Related Posts
裝了vsftp無法上傳
By Edith
at 2010-02-26T16:22
at 2010-02-26T16:22
關於編譯失敗的問題
By Agnes
at 2010-02-26T15:52
at 2010-02-26T15:52
ubuntu 9.04 外觀設定
By Emma
at 2010-02-26T15:00
at 2010-02-26T15:00
MySQL 有關資料庫路徑的設定放在何處
By Steve
at 2010-02-26T11:25
at 2010-02-26T11:25
剛使用Fedora 12 新手的問題
By Thomas
at 2010-02-26T02:41
at 2010-02-26T02:41