您好,想請問關於mysqlhotcopy錯誤訊息的問題

10 views
Skip to first unread message

Alma

unread,
Jan 27, 2010, 1:46:11 AM1/27/10
to MySQL技術轉運站, al...@taifon.com.tw
在Solaris上安裝的Mysql版本5.1.41-log MySQL Community Server及在RedHet上安裝的
Mysql版本5.1.35-enterprise-gpl-advanced-log MySQL Enterprise Server -
Advanced Edition (GPL)在執行備份mysql db都有遇到以下這個mysqlhotcopy的錯誤訊息:

DBD::mysql::db do failed: You can't use locks with log tables. at /usr/
local/mysql/bin/mysqlhotcopy line 452.


確認Perl有安裝成功,因為在執行備份其它的db都是可以成功執行的,結果如下:
root:/Desktop#/usr/local/mysql/bin/mysqlhotcopy --user=root --
password=test123 --addtodest aaa /Desktop
Locked 1 tables in 0 seconds.
Flushed tables (`aaa`.`aaa`) in 0 seconds.
Copying 4 files...
Copying indices for 0 files...
Unlocked tables.
mysqlhotcopy copied 1 tables (4 files) in 1 second (1 seconds
overall).
root:/Desktop#

  但唯獨只要有備份到mysql db就會出現錯誤訊息
root:/Desktop#/usr/local/mysql/bin/mysqlhotcopy --user=root --
password=test123 --addtodest mysql aaa /Desktop
DBD::mysql::db do failed: You can't use locks with log tables. at /usr/
local/mysql/bin/mysqlhotcopy line 452.

以下是在網路上有搜尋到的相關文章:
http://planet.mysql.com/entry/?id=17913
http://linux.chinaunix.net/bbs/archiver/?tid-1114499.html

  想請教您官方的作法會如何解決,或給予什麼建議,謝謝您!!

Reply all
Reply to author
Forward
0 new messages