우분투 mysqldump 설치

우분투 mysqldump 설치
우분투 mysql-client 설치

1 문제 상황[ | ]

root@zetawiki:~# mysql -V
mysql  Ver 14.14 Distrib 5.6.30, for debian-linux-gnu (x86_64) using  EditLine wrapper

root@zetawiki:~# mysqldump -V
The program 'mysqldump' can be found in the following packages:
 * mysql-client-5.5
 * mariadb-client-5.5
 * mysql-client-5.6
 * percona-xtradb-cluster-client-5.5
Try: apt-get install <selected package>

→ mysql은 되는데, mysqldump가 안됨

2 확인[ | ]

root@zetawiki:~# dpkg -l | grep -i mysql
ii  libmysqlclient18:amd64               5.5.49-0ubuntu0.14.04.1          amd64        MySQL database client library
ii  mysql-client-core-5.6                5.6.30-0ubuntu0.14.04.1          amd64        MySQL database core client binaries
ii  mysql-common                         5.5.49-0ubuntu0.14.04.1          all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  php5-mysql                           5.5.9+dfsg-1ubuntu4.17           amd64        MySQL module for php5

→ mysql은 mysql-client-core 에 있고, mysqldump는 mysql-client이 있는 모양이다.

→ mysql-client 를 설치하자.

3 mysql-client 설치 (실패)[ | ]

root@zetawiki:~# apt-get install mysql-client
... (생략)
The following packages have unmet dependencies:
 mysql-client : Depends: mysql-client-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

→ 이미 설치되어 있던 mysql-client-core는 5.6 버전인데 mysql-client 5.5가 선택되어 오류 발생

→ mysql-client-5.6을 설치하자.

4 mysql-client 설치 (성공)[ | ]

root@zetawiki:~# apt-get install mysql-client-5.6
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libdbi-perl mysql-common-5.6
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libplrpc-perl
  libsql-statement-perl
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl mysql-client-5.6 mysql-common-5.6
0 upgraded, 4 newly installed, 0 to remove and 130 not upgraded.
Need to get 6,677 kB of archives.
After this operation, 60.2 MB of additional disk space will be used.
Do you want to continue? [Y/n]

After this operation, 60.2 MB of additional disk space will be used.
Do you want to continue? [Y/n] 
Get:1 http://us.archive.ubuntu.com/ubuntu/ trusty/main libdbi-perl amd64 1.630-1 [879 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu/ trusty/main libdbd-mysql-perl amd64 4.025-1 [99.3 kB]
... (생략)
Setting up libdbd-mysql-perl (4.025-1) ...
Setting up mysql-client-5.6 (5.6.31-0ubuntu0.14.04.2) ...
Setting up mysql-common-5.6 (5.6.31-0ubuntu0.14.04.2) ...

5 확인 2[ | ]

root@zetawiki:~# mysqldump -V
mysqldump  Ver 10.13 Distrib 5.6.31, for debian-linux-gnu (x86_64)

6 같이 보기[ | ]