CMS솔루션마켓, 이온디 - 워드프레스, 라이믹스, 카페24, 그누보드, 엑셀

홈페이지 제작팁

서버관리
2020.05.21 15:53

mysqldump not found

조회 수 466 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄


root@q381-0663:/# mysqldump

bash: mysqldump: command not found


오랜만에 백업해보려니 mysqldump 명령어가 실행되지 않더군요..


$ which mysqldump 


위 명령어가 mysqldump를 찾는 명령어인데, 해보니 없는 거 같더군요.

아마 일전에 php7.4 업데이트할 때 같이 어떻게 되버린거 같았습니다;;



root@q381-0663:/# dpkg -l | grep -i mysql

ii  dbconfig-mysql                        2.0.4ubuntu1                                             all          dbconfig-common MySQL/MariaDB support

ii  libdbd-mysql-perl                     4.033-1ubuntu0.1                                         amd64        Perl5 database interface to the MySQL database

ii  libmysqlclient20:amd64                5.7.29-0ubuntu0.16.04.1                                  amd64        MySQL database client library

iU  mysql-client                          5.7.29-0ubuntu0.16.04.1                                  all          MySQL database client (metapackage depending on the la                                                                                                              test version)

iU  mysql-client-core-5.7                 5.7.29-0ubuntu0.16.04.1                                  amd64        MySQL database core client binaries

ii  mysql-common                          5.7.29-0ubuntu0.16.04.1                                  all          MySQL database common files, e.g. /etc/mysql/my.cnf

ii  php-mysql                             1:7.0+35ubuntu6.1                                        all          MySQL module for PHP [default]

ii  php7.0-mysql                          7.0.33-27+ubuntu16.04.1+deb.sury.org+1                   amd64        MySQL module for PHP

ii  php7.4-mysql                          7.4.5-1+ubuntu16.04.1+deb.sury.org+1                     amd64        MySQL module for PHP

rc  phpmyadmin                            4:4.5.4.1-2ubuntu2.1                                     all          MySQL web administration tool


$ dpkg -l | grep -i mysql


mysqldump를 찾아보니 이렇게 있긴 하던데,


ii가 있고 iU가 있던데 이건 또 뭔지 찾아보니..ㅠ



'ubuntu ii iu 차이' 이라고 구글링해보니깐 뜨더군요.

install Unkown인지 uninstall 인지 여튼-_-; 그런거 같아서..



root@q381-0663:/# apt-get install mysql-client-core-5.7

Reading package lists... Done

Building dependency tree

Reading state information... Done

You might want to run 'apt-get -f install' to correct these:

The following packages have unmet dependencies:

 mariadb-server-10.0 : Depends: mariadb-client-10.0 (>= 10.0.38-0ubuntu0.16.04.1) but it is not going to be installed

                       Recommends: libhtml-template-perl but it is not going to be installed

 mysql-client : Depends: mysql-client-5.7 but it is not going to be installed

E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

root@q381-0663:/# apt-get install mysql-client-5.7

Reading package lists... Done

Building dependency tree

Reading state information... Done

You might want to run 'apt-get -f install' to correct these:

The following packages have unmet dependencies:

 mariadb-server-10.0 : Depends: mariadb-client-10.0 (>= 10.0.38-0ubuntu0.16.04.1) but it is not going to be installed

                       Recommends: libhtml-template-perl but it is not going to be installed

E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

root@q381-0663:/# mysqldump

bash: mysqldump: command not found

root@q381-0663:/# apt-get -f install

Reading package lists... Done

Building dependency tree

Reading state information... Done

Correcting dependencies... Done

The following packages were automatically installed and are no longer required:

  apache2-data apache2-utils dbconfig-common dbconfig-mysql fakeroot fonts-dejavu fonts-dejavu-extra gettext javascript-common libapr1 libaprutil1

  libaprutil1-dbd-sqlite3 libaprutil1-ldap libasprintf-dev libfakeroot libgettextpo-dev libgettextpo0 libjs-jquery libjs-sphinxdoc libjs-underscore liblua5.1-0

  libnuma1 libpcre2-16-0 libpcre2-32-0 libpcre2-dev libpcre2-posix2 libssl-dev libssl-doc libunistring0 munin-doc php-gettext php-phpseclib php-tcpdf rrdtool

  zlib1g-dev

Use 'apt autoremove' to remove them.

The following additional packages will be installed:

  mariadb-client-10.0 mariadb-client-core-10.0

The following packages will be REMOVED:

  mysql-client mysql-client-core-5.7

The following NEW packages will be installed:

  mariadb-client-10.0 mariadb-client-core-10.0

0 upgraded, 2 newly installed, 2 to remove and 105 not upgraded.

3 not fully installed or removed.

Need to get 5,448 kB of archives.

After this operation, 14.0 MB of additional disk space will be used.

Do you want to continue? [Y/n] y

Get:1 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 mariadb-client-core-10.0 amd64 10.0.38-0ubuntu0.16.04.1 [4,286 kB]

Get:2 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 mariadb-client-10.0 amd64 10.0.38-0ubuntu0.16.04.1 [1,162 kB]

Fetched 5,448 kB in 2s (2,031 kB/s)

(Reading database ... 107730 files and directories currently installed.)

Removing mysql-client-core-5.7 (5.7.29-0ubuntu0.16.04.1) ...

Processing triggers for man-db (2.7.5-1) ...

Selecting previously unselected package mariadb-client-core-10.0.

(Reading database ... 107721 files and directories currently installed.)

Preparing to unpack .../mariadb-client-core-10.0_10.0.38-0ubuntu0.16.04.1_amd64.deb ...

Unpacking mariadb-client-core-10.0 (10.0.38-0ubuntu0.16.04.1) ...

Processing triggers for man-db (2.7.5-1) ...

dpkg: mysql-client: dependency problems, but removing anyway as you requested:

 dbconfig-mysql depends on mysql-client | mariadb-client | virtual-mysql-client; however:

  Package mysql-client is to be removed.

  Package mariadb-client is not installed.

  Package virtual-mysql-client is not installed.

  Package mariadb-client-10.0 which provides virtual-mysql-client is not installed.


(Reading database ... 107729 files and directories currently installed.)

Removing mysql-client (5.7.29-0ubuntu0.16.04.1) ...

Selecting previously unselected package mariadb-client-10.0.

(Reading database ... 107726 files and directories currently installed.)

Preparing to unpack .../mariadb-client-10.0_10.0.38-0ubuntu0.16.04.1_amd64.deb ...

Unpacking mariadb-client-10.0 (10.0.38-0ubuntu0.16.04.1) ...

Processing triggers for man-db (2.7.5-1) ...

Setting up mariadb-client-core-10.0 (10.0.38-0ubuntu0.16.04.1) ...

Setting up mariadb-client-10.0 (10.0.38-0ubuntu0.16.04.1) ...

Setting up libnuma1:amd64 (2.0.11-1ubuntu1.1) ...

Processing triggers for libc-bin (2.23-0ubuntu11) ...

root@q381-0663:/# mysqldump

Usage: mysqldump [OPTIONS] database [tables]

OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]

OR     mysqldump [OPTIONS] --all-databases [OPTIONS]

For more options, use mysqldump --help


$ apt-get -f install


성공!-_-;


참조

https://askubuntu.com/questions/735711/what-does-ii-mean-in-dpkg-list-command-output




참조

https://zetawiki.com/wiki/%EC%9A%B0%EB%B6%84%ED%88%AC_mysqldump_%EC%84%A4%EC%B9%98



기존대댓글
추가시작 대댓글시작
대댓글끝 추가끝


  1. innoDB 메모리 설정 방법

  2. No Image 03May
    by 이온디
    in 웹호스팅
    Views 85  Likes 0

    HestiaCP 사용방법

  3. HestiaCP 설치방법

  4. No Image 03Mar
    by 이온디
    in 리눅스
    Views 76  Likes 0

    리눅스 / 사용자 / 사용자 조회, 사용자 추가, 사용자 삭제, 사용자 수정

  5. No Image 03Mar
    by 이온디
    in 웹호스팅
    Views 85  Likes 0

    웹호스팅에서 php 설정 변경하는 방법

  6. No Image 03Mar
    by 이온디
    in 리눅스
    Views 100  Likes 0

    리스토리의 IT's/IT Story Mysql 설치후 phpMyadmin 접속 안될때 - Cannot start session

  7. No Image 03Mar
    by 이온디
    in 리눅스
    Views 92  Likes 0

    CentOS PHP/PHP-FPM 설치방법

  8. 리눅스 그룹 생성/삭제/확인/추가 - groupadd

  9. 15Jan
    by 이온디
    in VPS
    Views 87  Likes 0

    요즘 일방문자가 5000~6000씩 찍히는데 이유를 모르겠습니다.

  10. No Image 23Jun
    by 이온디
    in 웹호스팅
    Views 198  Likes 1

    사이트 백업하는 방법

  11. No Image 08Jul
    by 이온디
    in 리눅스
    Views 304  Likes 0

    리눅스 tar 특정폴더 제외하고 압축하기

  12. No Image 30Jun
    by 이온디
    in 서버관리
    Views 289  Likes 0

    아파치 재실행

  13. No Image 20Jun
    by 이온디
    in 서버관리
    Views 323  Likes 0

    압축해제

  14. No Image 20Jun
    by 이온디
    in 서버관리
    Views 316  Likes 0

    소유자 권한 설정

  15. No Image 20Jun
    by 이온디
    in 서버관리
    Views 328  Likes 0

    신규 유저 생성

  16. No Image 23May
    by 이온디
    in 서버관리
    Views 130  Likes 0

    Mysql 비밀번호 변경하는 방법

  17. No Image 21May
    by 이온디
    Views 243  Likes 0

    Mysqldump를 사용하여 MySQL데이터베이스를 백업 및 복원하는 방법

  18. No Image 21May
    by 이온디
    in 서버관리
    Views 466  Likes 0

    mysqldump not found

  19. No Image 21May
    by 이온디
    in 서버관리
    Views 0  Likes 0

    신규 사용자 생성

  20. No Image 21May
    by 이온디
    in 서버관리
    Views 239  Likes 0

    서버 이전

Board Pagination Prev 1 2 Next
/ 2