昨天在測試mydumper壓縮功能(-c)時,出現如下錯誤:
代碼如下 |
複製代碼 |
[root@liufofu backup]# mydumper -h localhost -u root -p tiger -c -o ./liufofu/ -B liufofu mydumper: relocation error: mydumper: symbol gzopen, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference |
定位了下libmysqlclient_16.so在mysql安裝目錄的lib下有啊,怎麼還報錯
代碼如下 |
複製代碼 |
[root@liufofu backup]# ls /usr/local/mysql/lib/ libdbug.a libmyisam.a libmysqlclient.la libmysqlclient_r.so libmysqlclient.so libmysqld.a libvio.a plugin libheap.a libmyisammrg.a libmysqlclient_r.a libmysqlclient_r.so.16 libmysqlclient.so.16 libmystrings.a libz.a libmygcc.a libmysqlclient.a libmysqlclient_r.la libmysqlclient_r.so.16.0.0 libmysqlclient.so.16.0.0 libmysys.a libz.la |
查了下資料應該是系統沒有引用這個目錄,可以定義下環境變數LD_LIBRARY_PATH,加入/usr/local/mysql/lib這個目錄,命令如下:
代碼如下 |
複製代碼 |
export LD_LIBRARY_PATH="/usr/local/mysql/lib:$LD_LIBRARY_PATH" |
再次執行mydumper壓縮功能就沒問題了。