호스팅 이야기 나눠주세요.
글 등록하기 | 내글 관리하기 | 연재글 | 보관함
mysqldump not found
첨부파일 https://eond.com/hosting_forum/434282


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



코멘트 0
접기/펴기 | 댓글 새로고침
 
 
Total 25 articles in 1 / 2 pages
번호 제목 제목 날짜날짜 조회 수
25 [쉐어드호스팅 팁] Mysql 비밀번호 변경하는 방법 2020/05/23 18
24 Mysqldump를 사용하여 MySQL데이터베이스를 백업 및 복원하는 방법 2020/05/21 36
현재글 [쉐어드호스팅 팁] mysqldump not found 2020/05/21 36
22 [쉐어드호스팅 팁] 비밀글 신규 사용자 생성 2020/05/21 0
21 [쉐어드호스팅 팁] 서버 이전 2020/05/21 23
20 [리눅스팁] Htop (Linux Process Monitoring) 사용법 파일 2020/05/05 6
19 [리눅스팁] postfix 메일에서 queue 관리 2020/05/04 7
18 [리눅스팁] pstree 현재 사용자 프로세스 확인 2020/05/04 8
17 [리눅스팁] How to remove imagemagick from Ubuntu 16.04 (Xenial Xerus) 2020/05/03 8
16 [리눅스팁] top 에서 실행 중인 프로세스에서 어떤 파일이 사용되는지 파악하는 방법 파일 2020/05/03 2
15 [리눅스팁] NGINX PHP-FPM 업데이트 및 여러 버전 동시 연동 방법 2020/05/02 0
14 [리눅스팁] Linux/Ubuntu, 용량 큰 파일/디렉토리 찾아내기. 파일 2020/05/02 1
13 [리눅스팁] [Laravel] 라라벨 설치하기 PHP7.0 + Nginx 파일 [5] 2020/05/01 0
12 [리눅스팁] 루분투 X61 배터리 정보 파일 [1] 2019/01/16 24
11 [가상서버호스팅] 리노드에서 서비스 변경했습니다. (160달러 -> 10달러로) 파일 2018/01/01 63
10 [가상서버호스팅] Linode VPS 디스크 용량 변경 방법 파일 2017/07/26 45
9 [가상서버호스팅] Linode VPS의 새로운 콘트롤 패널 파일 2017/07/15 116
8 [가상서버호스팅] 각종 클라우드 VPS 서비스 비교해본 소감 2017/06/07 310
7 [웹호스팅] 비밀글 http://rael.me/support.php 2017/06/07 0
6 [AWS(아마존 웹서비스)] 무료 아마존 웹 서비스, 100% 알뜰하게 사용하는 방법 2017/02/17 48

해시태그 디렉터리