mysql innobackupex 的一則錯誤
-bash-3.2$ ./innobackupex --version-check /usr/mysql/xtraback/xtrabackup03
InnoDB Backup Utility v1.5.1-xtrabackup;
150930 17:16:26 innobackupex: Executing a version check against the server...
150930 17:16:26 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
150930 17:16:26 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
報這樣一個錯誤。這個錯誤原因是innobackupex是用perl語言寫的,perl要透過perl DBI模組和DBD-mysql模組呼叫mysql資料庫來執行。
所以,需要安裝包perl-DBD-MySQL。安裝這個包,會遇到錯誤:
yum install perl-DBD-MySQL。採用這個命令安裝會出現如下錯誤:
Transaction Check Error:
file /etc/my.cnf from install of mysql-5.0.77-4.el5_5.4.i386 conflicts with file from package MySQL-server-5.6.25-1.linux_glibc2.5.i386
原因是:perl-DBD-MySQL對應了5.0版本的mysql,而你安裝的5.6的版本mysql。解決辦法是手動安裝DBD。
請參考我的文章 http://blog.itpub.net/30393770/viewspace-1813513/ 。
InnoDB Backup Utility v1.5.1-xtrabackup;
150930 17:16:26 innobackupex: Executing a version check against the server...
150930 17:16:26 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1551
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
150930 17:16:26 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
innobackupex: got a fatal error with the following stacktrace: at ./innobackupex line 3006
main::mysql_connect('abort_on_error', 1) called at ./innobackupex line 1570
innobackupex: Error: Failed to connect to MySQL server as DBD::mysql module is not installed at ./innobackupex line 3006.
所以,需要安裝包perl-DBD-MySQL。安裝這個包,會遇到錯誤:
yum install perl-DBD-MySQL。採用這個命令安裝會出現如下錯誤:
Transaction Check Error:
file /etc/my.cnf from install of mysql-5.0.77-4.el5_5.4.i386 conflicts with file from package MySQL-server-5.6.25-1.linux_glibc2.5.i386
原因是:perl-DBD-MySQL對應了5.0版本的mysql,而你安裝的5.6的版本mysql。解決辦法是手動安裝DBD。
請參考我的文章 http://blog.itpub.net/30393770/viewspace-1813513/ 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30393770/viewspace-2123583/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql匯入資料亂碼錯誤一則MySql
- mysql 一個錯誤MySql
- 【MySQL】錯誤資訊寫入slave_relay_log.index 案例一則MySqlIndex
- ruby2.2安裝錯誤一則
- 關於”kccrsz“錯誤處理一則
- 【MySql】innobackupex 增量備份的bugMySql
- mysql innobackupex 物理備份MySql
- Mysql錯誤集MySql
- MySQL增量備份的指令碼(innobackupex)MySql指令碼
- 故障分析 | 從一則錯誤日誌到 MySQL 認證機制與 bug 的深入分析MySql
- mysql innobackupex備份指令碼MySql指令碼
- 【MySQL】innobackupex長時間hangMySql
- 【MySQL】innobackupex 長時間hangMySql
- 【拖雷】一則ORA-12500錯誤的解決案例
- 【MySQL】解決mysql的 1594 錯誤MySql
- Oracle 11.2.0.2 exp匯出錯誤處理一則Oracle
- MySQL 錯誤程式碼MySql
- MySQL 常見錯誤MySql
- MySQL error 錯 誤 碼MySqlError
- mysql slave錯誤skipMySql
- mysql 啟動錯誤MySql
- innobackupex 備份MySQL資料庫MySql資料庫
- mysql innobackupex增量備份恢復MySql
- mysql的時區錯誤問題MySql
- mysql錯誤碼的檢視方法MySql
- MySQL2059錯誤MySql
- MySQL錯誤程式碼大全MySql
- mysql replication常見錯誤MySql
- MySQL 跳過同步錯誤MySql
- 使用innobackupex恢復mysql資料庫MySql資料庫
- 使用innobackupex備份mysql資料庫MySql資料庫
- 【MySql】innobackupex增量備份和恢復MySql
- MySQL innobackupex全量備份恢復MySql
- 【MySql】innobackupex 增量備份和恢復MySql
- 蓄意協議錯誤:蘭利法則協議
- 記錄一次根據錯誤資訊無法定位錯誤的錯誤
- PHP開發者常犯的10個MySQL錯誤PHPMySql
- 關於mysql 1067的錯誤MySql