我現在備份都是直接把mysql備份起來,
這樣的話,以後我還原會不會有問題?
或是仍需備份某些東西?
資料庫當然是直接備份就好!但是你也要記得把/pLog folder 也備份起來,否則你會要 restore 的時候,你可是會失掉所有對模版的修改
Mark
關於Restore的問題
麻煩以下各位板友,小弟也是直接輩分mysql資料夾,確定資料庫mysql應該有備份起來了
因為我mysql上有一個論壇的資料庫,移植到新系統上時讀的到之前備份的mysql資料
但是我嘗試著把備份後的plog資料夾放到新伺服器上時卻發生以下的錯誤
我做的事情是
1.把舊機器上的mysql資料夾備份,並移植到新機器上
2.把plog資料夾備份移植至新機器上
3.當我要連結首頁
http://localhost/plog 時就發生以下的錯誤
----------error message -----------------------
Exception message: fopen(tmp/sql_error.log): failed to open stream: Permission denied
Error code: 2
-- Backtrace --
/var/www/html/plog/class/logger/appender/fileappender.class.php(57): fopen
/var/www/html/plog/class/logger/appender/fileappender.class.php(43): fileappender.openfp
/var/www/html/plog/class/logger/loggermanager.class.php(142): fileappender.fileappender
/var/www/html/plog/class/logger/loggermanager.class.php(114): loggermanager.createappenderinstance
/var/www/html/plog/class/logger/loggermanager.class.php(87): loggermanager._loadloggerconfig
/var/www/html/plog/class/logger/loggermanager.class.php(177): loggermanager.loggermanager
/var/www/html/plog/class/logger/loggermanager.class.php(192): loggermanager.getinstance
/var/www/html/plog/class/template/template.class.php(56): loggermanager.getlogger
/var/www/html/plog/class/template/cachedtemplate.class.php(30): cachedtemplate.template
/var/www/html/plog/class/template/templateservice.class.php(173): cachedtemplate.cachedtemplate
/var/www/html/plog/class/view/smartyview.class.php(70): templateservice.cachedtemplate
/var/www/html/plog/class/view/blogview.class.php(39): defaultview.smartyview
/var/www/html/plog/class/view/defaultview.class.php(23): defaultview.blogview
/var/www/html/plog/class/action/defaultaction.class.php(69): defaultview.defaultview
/var/www/html/plog/class/controller/controller.class.php(305): defaultaction.perform
/var/www/html/plog/index.php(44): blogcontroller.process
Exception message: Cannot open log file: tmp/sql_error.log
Error code: 0
-- Backtrace --
/var/www/html/plog/class/logger/appender/fileappender.class.php(59): throw
/var/www/html/plog/class/logger/appender/fileappender.class.php(43): fileappender.openfp
/var/www/html/plog/class/logger/loggermanager.class.php(142): fileappender.fileappender
/var/www/html/plog/class/logger/loggermanager.class.php(114): loggermanager.createappenderinstance
/var/www/html/plog/class/logger/loggermanager.class.php(87): loggermanager._loadloggerconfig
/var/www/html/plog/class/logger/loggermanager.class.php(177): loggermanager.loggermanager
/var/www/html/plog/class/logger/loggermanager.class.php(192): loggermanager.getinstance
/var/www/html/plog/class/template/template.class.php(56): loggermanager.getlogger
/var/www/html/plog/class/template/cachedtemplate.class.php(30): cachedtemplate.template
/var/www/html/plog/class/template/templateservice.class.php(173): cachedtemplate.cachedtemplate
/var/www/html/plog/class/view/smartyview.class.php(70): templateservice.cachedtemplate
/var/www/html/plog/class/view/blogview.class.php(39): defaultview.smartyview
/var/www/html/plog/class/view/defaultview.class.php(23): defaultview.blogview
/var/www/html/plog/class/action/defaultaction.class.php(69): defaultview.defaultview
/var/www/html/plog/class/controller/controller.class.php(305): defaultaction.perform
/var/www/html/plog/index.php(44): blogcontroller.process