亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 學院 > 操作系統 > 正文

mydumper安裝報錯處理

2024-06-28 14:32:38
字體:
來源:轉載
供稿:網友

mydumper 官網:https://answers.launchpad.net/mydumper/

下載之后,安裝報錯:

[root@localhost local]# cd mydumper-0.6.2[root@localhost mydumper-0.6.2]#[root@localhost mydumper-0.6.2]# lsbinlog.c  CMakeCache.txt  common.h     docs             g_unix_signal.h  myloader.c  PRocessing  server_detect.cbinlog.h  CMakeFiles      config.h     Finished         mydumper.c       myloader.h  README      server_detect.hcmake     CMakeLists.txt  config.h.in  g_unix_signal.c  mydumper.h       Package     Running[root@localhost mydumper-0.6.2]# cmake .-- The CXX compiler identification is GNU 4.4.7-- Check for working CXX compiler: /usr/bin/c++-- Check for working CXX compiler: /usr/bin/c++ -- works-- Detecting CXX compiler ABI info-- Detecting CXX compiler ABI info - done-- Using MySQL-config: /usr/local/mysql/bin/mysql_config-- Found MySQL: /usr/local/mysql/include, /usr/local/mysql/lib/libmysqlclient.so;/usr/lib/libpthread.so;/usr/lib/libm.so;/usr/lib/librt.so;/usr/lib/libdl.so-- checking for one of the modules 'glib-2.0'CMake Error at /usr/share/cmake/Modules/FindPkgConfig.cmake:363 (message):  None of the required 'glib-2.0' foundCall Stack (most recent call first):  cmake/modules/FindGLIB2.cmake:10 (pkg_search_module)  CMakeLists.txt:10 (find_package)-- checking for one of the modules 'gthread-2.0'CMake Error at /usr/share/cmake/Modules/FindPkgConfig.cmake:363 (message):  None of the required 'gthread-2.0' foundCall Stack (most recent call first):  cmake/modules/FindGLIB2.cmake:11 (pkg_search_module)  CMakeLists.txt:10 (find_package)CMake Warning at docs/CMakeLists.txt:9 (message):  Unable to find Sphinx documentation generator-- -------------------------------------------------- MYSQL_CONFIG = /usr/local/mysql/bin/mysql_config-- CMAKE_INSTALL_PREFIX = /usr/local-- BUILD_DOCS = ON-- WITH_BINLOG = OFF-- RUN_CPPCHECK = OFF-- Change a values with: cmake -D<Variable>=<Value>-- --------------------------------------------------CMake Error: The following variables are used in this project, but they are set to NOTFOUND.Please set them or make sure they are set and tested correctly in the CMake files:GLIB2_LIBRARIES (ADVANCED)    linked by target "mydumper" in directory /usr/local/mydumper-0.6.2    linked by target "myloader" in directory /usr/local/mydumper-0.6.2GTHREAD2_LIBRARIES (ADVANCED)    linked by target "mydumper" in directory /usr/local/mydumper-0.6.2    linked by target "myloader" in directory /usr/local/mydumper-0.6.2-- Configuring incomplete, errors occurred!See also "/usr/local/mydumper-0.6.2/CMakeFiles/CMakeOutput.log".See also "/usr/local/mydumper-0.6.2/CMakeFiles/CMakeError.log".

cmake .  報錯:

None of the required 'glib-2.0' foundNone of the required 'gthread-2.0' found

網上搜索,沒有找到解決辦法,于是只好去官網尋找方法:

https://answers.launchpad.net/mydumper/+faq/349

Run: cmake . makeOne needs to install development versions of required libaries (MySQL, GLib, ZLib, PCRE):NOTE: you must use the correspondent mysql devel package.* Ubuntu or Debian: apt-get install libglib2.0-dev libmysqlclient15-dev zlib1g-dev libpcre3-dev libssl-dev* Fedora, RedHat and CentOS: yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel* openSUSE: zypper install glib2-devel libmysqlclient-devel pcre-devel zlib-devel* MacOSX: port install glib2 mysql5 pcre pkgconfig cmake (You may want to run 'port select mysql mysql5' afterwards)One has to make sure, that pkg-config, mysql_config, pcre-config are all in $PATHBinlog dump is disabled by default to compile with it you need to add -DWITH_BINLOG=ON to cmake optionsObviously you need compiler and make packages too :)

可以看到需要安裝依賴:

Fedora, RedHat and CentOS: yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-devel

于是按照說明進行安裝:

[root@localhost mydumper-0.6.2]# yum install glib2-devel mysql-devel zlib-devel pcre-devel openssl-develLoaded plugins: fastestmirror, refresh-packagekit, securitySetting up Install ProcessLoading mirror speeds from cached hostfile * c6-media:Package mysql-devel-5.1.73-3.el6_5.i686 already installed and latest versionPackage zlib-devel-1.2.3-29.el6.i686 already installed and latest versionPackage pcre-devel-7.8-6.el6.i686 already installed and latest versionPackage openssl-devel-1.0.1e-30.el6.i686 already installed and latest versionResolving Dependencies--> Running transaction check---> Package glib2-devel.i686 0:2.28.8-4.el6 will be installed--> Finished Dependency ResolutionDependencies Resolved========================================================================================================================================== Package                            Arch                        Version                             Repository                       Size==========================================================================================================================================Installing: glib2-devel                        i686                        2.28.8-4.el6                        c6-media                        298 kTransaction Summary==========================================================================================================================================Install       1 Package(s)Total download size: 298 kInstalled size: 1.5 MIs this ok [y/N]: yDownloading Packages:Running rpm_check_debugRunning Transaction TestTransaction Test SucceededRunning Transaction  Installing : glib2-devel-2.28.8-4.el6.i686                                                                                          1/1Unable to connect to dbus  Verifying  : glib2-devel-2.28.8-4.el6.i686                                                                                          1/1Installed:  glib2-devel.i686 0:2.28.8-4.el6Complete!

再來編譯安裝 mydumper:

[root@localhost mydumper-0.6.2]# cmake .-- Using mysql-config: /usr/local/mysql/bin/mysql_config-- Found MySQL: /usr/local/mysql/include, /usr/local/mysql/lib/libmysqlclient.so;/usr/lib/libpthread.so;/usr/lib/libm.so;/usr/lib/librt.so;/usr/lib/libdl.so-- checking for one of the modules 'glib-2.0'-- checking for one of the modules 'gthread-2.0'CMake Warning at docs/CMakeLists.txt:9 (message):  Unable to find Sphinx documentation generator-- -------------------------------------------------- MYSQL_CONFIG = /usr/local/mysql/bin/mysql_config-- CMAKE_INSTALL_PREFIX = /usr/local-- BUILD_DOCS = ON-- WITH_BINLOG = OFF-- RUN_CPPCHECK = OFF-- Change a values with: cmake -D<Variable>=<Value>-- ---------------------------------------------------- Configuring done-- Generating done-- Build files have been written to: /usr/local/mydumper-0.6.2[root@localhost mydumper-0.6.2]# echo $?0[root@localhost mydumper-0.6.2]# makeScanning dependencies of target mydumper[ 25%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o[ 50%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o[ 75%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.oLinking C executable mydumper[ 75%] Built target mydumperScanning dependencies of target myloader[100%] Building C object CMakeFiles/myloader.dir/myloader.c.oLinking C executable myloader[100%] Built target myloader[root@localhost mydumper-0.6.2]# make install[ 75%] Built target mydumper[100%] Built target myloaderInstall the project...-- Install configuration: ""-- Installing: /usr/local/bin/mydumper-- Removed runtime path from "/usr/local/bin/mydumper"-- Installing: /usr/local/bin/myloader-- Removed runtime path from "/usr/local/bin/myloader"

安裝成功。但是執行時又報錯:

[root@localhost mydumper-0.6.2]# mydumper --helpmydumper: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory

解決辦法:

[root@localhost mydumper-0.6.2]# ldd /usr/local/bin/mydumper        linux-gate.so.1 =>  (0x00f91000)        libmysqlclient.so.18 => not found        libpthread.so.0 => /lib/libpthread.so.0 (0x006fc000)        libm.so.6 => /lib/libm.so.6 (0x0072b000)        librt.so.1 => /lib/librt.so.1 (0x00720000)        libdl.so.2 => /lib/libdl.so.2 (0x00719000)        libglib-2.0.so.0 => /lib/libglib-2.0.so.0 (0x00757000)        libgthread-2.0.so.0 => /lib/libgthread-2.0.so.0 (0x00918000)        libpcre.so.0 => /lib/libpcre.so.0 (0x021a8000)        libz.so.1 => /lib/libz.so.1 (0x002ea000)        libc.so.6 => /lib/libc.so.6 (0x00564000)        /lib/ld-linux.so.2 (0x0053e000)[root@localhost mydumper-0.6.2]#  LD_DEBUG=libs /usr/local/bin/mydumper -v      2707:     find library=libmysqlclient.so.18 [0]; searching      2707:      search cache=/etc/ld.so.cache      2707:      search path=/lib/tls/i686/sse2:/lib/tls/i686:/lib/tls/sse2:/lib/tls:/lib/i686/sse2:/lib/i686:/lib/sse2:/lib:/usr/lib/tls /i686/sse2:/usr/lib/tls/i686:/usr/lib/tls/sse2:/usr/lib/tls:/usr/lib/i686/sse2:/usr/lib/i686:/usr/lib/sse2:/usr/lib             (system s earch path)      2707:       trying file=/lib/tls/i686/sse2/libmysqlclient.so.18      2707:       trying file=/lib/tls/i686/libmysqlclient.so.18      2707:       trying file=/lib/tls/sse2/libmysqlclient.so.18      2707:       trying file=/lib/tls/libmysqlclient.so.18      2707:       trying file=/lib/i686/sse2/libmysqlclient.so.18      2707:       trying file=/lib/i686/libmysqlclient.so.18      2707:       trying file=/lib/sse2/libmysqlclient.so.18      2707:       trying file=/lib/libmysqlclient.so.18      2707:       trying file=/usr/lib/tls/i686/sse2/libmysqlclient.so.18      2707:       trying file=/usr/lib/tls/i686/libmysqlclient.so.18      2707:       trying file=/usr/lib/tls/sse2/libmysqlclient.so.18      2707:       trying file=/usr/lib/tls/libmysqlclient.so.18      2707:       trying file=/usr/lib/i686/sse2/libmysqlclient.so.18      2707:       trying file=/usr/lib/i686/libmysqlclient.so.18      2707:       trying file=/usr/lib/sse2/libmysqlclient.so.18      2707:       trying file=/usr/lib/libmysqlclient.so.18

沒有找到 libmysqlclient.so.18

[root@localhost mydumper-0.6.2]# locate libmysqlclient.so.18/usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18/usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18.1.0[root@localhost mydumper-0.6.2]# ll /usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18lrwxrwxrwx. 1 root mysql 24 Aug 13 14:18 /usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18 -> libmysqlclient.so.18.1.0

然后將 /usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18.1.0 復制到 /usr/lib/ 木下:

[root@localhost mydumper-0.6.2]# cp /usr/local/mysql-5.6.26-linux-glibc2.5-i686/lib/libmysqlclient.so.18.1.0 /usr/lib/libmysqlclient.so.18[root@localhost mydumper-0.6.2]# ldd /usr/local/bin/mydumper                                                                                      linux-gate.so.1 =>  (0x00805000)        libmysqlclient.so.18 => /usr/lib/libmysqlclient.so.18 (0x0019f000)        libpthread.so.0 => /lib/libpthread.so.0 (0x006fc000)        libm.so.6 => /lib/libm.so.6 (0x0072b000)        librt.so.1 => /lib/librt.so.1 (0x00720000)        libdl.so.2 => /lib/libdl.so.2 (0x00719000)        libglib-2.0.so.0 => /lib/libglib-2.0.so.0 (0x0055e000)        libgthread-2.0.so.0 => /lib/libgthread-2.0.so.0 (0x00918000)        libpcre.so.0 => /lib/libpcre.so.0 (0x021a8000)        libz.so.1 => /lib/libz.so.1 (0x0067b000)        libc.so.6 => /lib/libc.so.6 (0x0091d000)        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x07b14000)        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x0068f000)        /lib/ld-linux.so.2 (0x0053e000)

測試:

[root@localhost mydumper-0.6.2]# mydumper --helpUsage:  mydumper [OPTION...] multi-threaded MySQL dumpingHelp Options:  -?, --help                  Show help optionsapplication Options:  -B, --database              Database to dump  -T, --tables-list           Comma delimited table list to dump (does not exclude regex option)  -o, --outputdir             Directory to output files to  -s, --statement-size        Attempted size of INSERT statement in bytes, default 1000000  -r, --rows                  Try to split tables into chunks of this many rows. This option turns off --chunk-filesize  -F, --chunk-filesize        Split tables into chunks of this output file size. This value is in MB  -c, --compress              Compress output files  -e, --build-empty-files     Build dump files even if no data available from table  -x, --regex                 Regular expression for 'db.table' matching  -i, --ignore-engines        Comma delimited list of storage engines to ignore  -m, --no-schemas            Do not dump table schemas with the data  -k, --no-locks              Do not execute the temporary shared read lock.  WARNING: This will cause inconsistent backups  --less-locking              Minimize locking time on InnoDB tables.  -l, --long-query-guard      Set long query timer in seconds, default 60  -K, --kill-long-queries     Kill long running queries (instead of aborting)  -D, --daemon                Enable daemon mode  -I, --snapshot-interval     Interval between each dump snapshot (in minutes), requires --daemon, default 60  -L, --logfile               Log file name to use, by default stdout is used  --tz-utc                    SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.  --skip-tz-utc  --use-savepoints            Use savepoints to reduce metadata locking issues, needs SUPER privilege  --success-on-1146           Not increment error count and Warning instead of Critical in case of table doesn't exist  --lock-all-tables           Use LOCK TABLE for all, instead of FTWRL  -h, --host                  The host to connect to  -u, --user                  Username with privileges to run the dump  -p, --passWord              User password  -P, --port                  TCP/IP port to connect to  -S, --socket                UNIX domain socket file to use for connection  -t, --threads               Number of threads to use, default 4  -C, --compress-protocol     Use compression on the MySQL connection  -V, --version               Show the program version and exit  -v, --verbose               Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2

搞定。

啟發:解決問題的最好方法是到官網查看文檔和說明。

 


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
国产精品久久久久久久av大片| 清纯唯美日韩制服另类| 日韩欧美在线视频日韩欧美在线视频| 国产精品v片在线观看不卡| 久久久久久久久久久人体| 久久久久久久久久久久av| 久久久精品网站| 亚洲免费一在线| 色综合视频网站| 亚洲精品一区二区久| 国产精品2018| 久久精品一偷一偷国产| 在线精品国产成人综合| 亚洲va欧美va国产综合久久| 97人洗澡人人免费公开视频碰碰碰| 91豆花精品一区| 亚洲日本中文字幕免费在线不卡| 欧美精品久久久久久久久| 91免费观看网站| 日韩精品中文字| 欧美性20hd另类| 国产精品久久久久久久久久免费| 欧美极品少妇全裸体| 欧美激情精品久久久久久黑人| 成人国产精品一区二区| 秋霞av国产精品一区| 亚洲午夜未满十八勿入免费观看全集| 国产成人欧美在线观看| 91高清免费在线观看| 欧美成人第一页| 精品久久久久久久久久国产| 久久久之久亚州精品露出| 中文精品99久久国产香蕉| 97精品视频在线| 亚洲欧美日韩成人| 亚洲自拍欧美另类| 日韩国产中文字幕| 国产欧美一区二区三区在线看| 尤物九九久久国产精品的特点| 538国产精品一区二区免费视频| 伊人久久大香线蕉av一区二区| 欧美大尺度激情区在线播放| 精品高清一区二区三区| 亚洲免费高清视频| 国产精品视频公开费视频| 国产精品久久久久久久久久| 欧美大秀在线观看| 亚洲级视频在线观看免费1级| 精品国产电影一区| 日韩精品免费在线播放| 久久免费视频这里只有精品| 在线视频国产日韩| 日韩电影免费观看中文字幕| 国产精品美乳一区二区免费| 两个人的视频www国产精品| 日本aⅴ大伊香蕉精品视频| 亚洲黄色成人网| 日韩美女免费线视频| 日韩影视在线观看| 亚洲欧美成人一区二区在线电影| 欧美午夜激情在线| 欧美在线视频一二三| 美女久久久久久久久久久| 在线成人激情视频| 国产一区二区三区丝袜| 精品久久中文字幕久久av| 久久精视频免费在线久久完整在线看| 亚洲人成网站色ww在线| 国内精品久久久久影院 日本资源| 国产成人激情视频| 性色av一区二区三区红粉影视| 成人观看高清在线观看免费| 在线观看中文字幕亚洲| 国内精品久久久久影院优| 色噜噜国产精品视频一区二区| 伊人成人开心激情综合网| 亚洲人成毛片在线播放| 久热国产精品视频| 欧美伦理91i| 高清亚洲成在人网站天堂| 一本色道久久88精品综合| 91久久综合亚洲鲁鲁五月天| 欧美精品久久久久久久久| 高潮白浆女日韩av免费看| 亚洲精品福利资源站| 国产在线观看一区二区三区| www.日韩免费| 久久久中精品2020中文| 欧美在线激情视频| 91国内免费在线视频| 日日噜噜噜夜夜爽亚洲精品| 国产999精品久久久影片官网| 国产亚洲视频中文字幕视频| 国产精品欧美在线| 精品偷拍各种wc美女嘘嘘| 亚洲欧美精品一区| 欧美日韩激情视频8区| 欧美日韩中国免费专区在线看| 91精品国产91久久久久福利| 国产精品老女人精品视频| 亚洲丁香婷深爱综合| 欧美一级大片视频| 在线观看国产精品91| 国产精品综合久久久| 91免费国产网站| 国产精品日韩在线一区| 亚洲综合中文字幕在线观看| 91亚洲国产成人精品性色| 国产精品综合久久久| 色综合久久天天综线观看| 色无极亚洲影院| 亚洲成人av资源网| 少妇高潮久久77777| 久久精品久久久久久| 日本免费一区二区三区视频观看| 欧美激情xxxx性bbbb| 亚洲免费高清视频| 欧美亚洲另类制服自拍| 琪琪第一精品导航| 亚洲激情中文字幕| 欧美极品少妇xxxxⅹ免费视频| 欧美资源在线观看| 国产亚洲精品美女| 国产综合在线观看视频| 亚洲在线www| 国产z一区二区三区| 亚洲精品免费一区二区三区| 久久久国产影院| 国产免费一区二区三区在线能观看| 黑人巨大精品欧美一区二区免费| 尤物精品国产第一福利三区| 亚洲成人精品久久| 国产精品永久免费视频| 热久久免费视频精品| 亚洲第一中文字幕| 国产亚洲精品久久久| 91超碰中文字幕久久精品| 538国产精品视频一区二区| 国产mv免费观看入口亚洲| 亚洲欧美日韩精品久久| 久久成人免费视频| 亚洲精品视频二区| 国产精品成人品| 992tv在线成人免费观看| 欧美午夜无遮挡| 欧美精品一本久久男人的天堂| 亚洲欧美另类自拍| 一区二区在线视频| 91精品久久久久| 日韩欧美国产免费播放| 97国产suv精品一区二区62| 日韩中文字幕在线视频| 欧美大片免费观看| 91精品视频一区| 国产欧美日韩精品在线观看| 国产精品吴梦梦| 日韩精品中文字幕在线观看| 91禁外国网站| 亚洲电影免费在线观看| 欧美成人一区二区三区电影| 久久亚洲欧美日韩精品专区| 欧美大尺度在线观看| 欧美成人免费观看| 亚洲日韩中文字幕|