如何修改mysql資料庫儲放資料夾 - Linux
By Todd Johnson
at 2009-11-09T11:05
at 2009-11-09T11:05
Table of Contents
請問如何修改mysql 儲放資料夾目錄
本來預設應該是/var/lib/mysql
如何改到/home/mysql 或是/opt/mysql
請指教 謝謝 OS:ubuntu 804 LTS
目前找到的資訊有
修改/etc/mysqld/my.cnf 裡面的datadir選項
將舊的/var/lib/mysql複製到新的位置
cp -R -p /var/lib/mysql /home/mysql
重新啟動mysql
/etc/init.d/mysqld restart 重啟失敗 但datadir 改回預設值就能順利重啟
--
╭ 這篇文章讓你覺得?═════════════════════════╮
║ by ycat ║y
║ ──+ ︵ ︵ . .! ˇ ˇ ╲ ╱ ˇˇ || ◣ ◢║c
║ ̄﹀ ̄  ̄▽ ̄ ▄ ▇△▇ ≧﹏≦b  ̄︶ ̄y  ̄– ̄ 皿 ║a
║ 新奇 溫馨 誇張 難過 實用 高興 無聊 生氣 ║t
╰══════════════════════════════════ ╯
--
Tags:
Linux
All Comments
Related Posts
解決ubuntu 9.10 ttf-mscorefonts-inst …
By Callum
at 2009-11-09T10:32
at 2009-11-09T10:32
請問postfix設定檔的參數問題
By Elvira
at 2009-11-09T03:10
at 2009-11-09T03:10
解決ubuntu 9.10 ttf-mscorefonts-installer連線錯誤
By Ursula
at 2009-11-09T03:00
at 2009-11-09T03:00
更新至2.6.30後聲音變非常小聲
By Emily
at 2009-11-09T02:46
at 2009-11-09T02:46
上youtube看影片 ubuntu9.10
By Adele
at 2009-11-08T21:50
at 2009-11-08T21:50