下面來給各位介紹一下linux中mydumper出現libmysqlclient_16 not defined解決辦法,希望例子能幫助到各位同學.

昨天在測試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下有啊,怎么還報錯,代碼如下:

1. [root@liufofu backup]# ls /usr/local/mysql/lib/ 
2. libdbug.a   libmyisam.a       libmysqlclient.la    libmysqlclient_r.so          
3. libmysqlclient.so         libmysqld.a     libvio.a  plugin 
4. libheap.a   libmyisammrg.a    libmysqlclient_r.a   libmysqlclient_r.so.16      
5. libmysqlclient.so.16      libmystrings.a  libz.a 
6. libmygcc.a  libmysqlclient.a  libmysqlclient_r.la  libmysqlclient_r.so.16.0.0    --Vevb.com 
7. 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壓縮功能就沒問題了.