Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Error when upgrading MySQL
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Error when upgrading MySQL

ShamliShamli Member
edited August 2012 in General

Hi everyone.

On routine update/upgrade on every VPS I have. Suddenly I get an error and it's only on one server. I get error on MySQL dependencies. I have tried as shown below,but still failed.

I dont want to reinstall the VPS as it's the main server with DNS and many other stuff. It's Debian 6.

Can anyone help me..

232703:~# apt-get upgrade
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:
 mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not installed
E: Unmet dependencies. Try using -f.
232703:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following package was automatically installed and is no longer required:
  mysql-client-core-5.5
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  mysql-client-5.1
Suggested packages:
  libterm-readkey-perl
The following NEW packages will be installed:
  mysql-client-5.1
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/9587 kB of archives.
After this operation, 22.9 MB of additional disk space will be used.
Do you want to continue [Y/n]?
(Reading database ... 44662 files and directories currently installed.)
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.63-0+squeeze1_i386.deb) ...
dpkg: error processing /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb (--unpack):
 trying to overwrite '/usr/bin/mysqlcheck', which is also in package mysql-client-core-5.5 5.5.25a-1~dotdeb.1
configured to not write apport reports
                                      dpkg-deb: subprocess paste killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
232703:~#

Thanks in advance...

Comments

  • gbshousegbshouse Member, Host Rep

    It look like you have newer client version already installed

  • already tried a dpgk-reconfigure ?

  • yeah..i'm also think like that..but it seems I can do nothing to remove this error..unless someone can show me the way...

    mysqld is running as normal,but cant be restart/reload...

  • @mistert

    232703:~# dpkg-reconfigure mysql
    Package `mysql' is not installed and no info is available.
    Use dpkg --info (= dpkg-deb --info) to examine archive files,
    and dpkg --contents (= dpkg-deb --contents) to list their contents.
    /usr/sbin/dpkg-reconfigure: mysql is not installed
    
    
  • @Shamli ofcourse you need the exact name of the package...f.e. mysql-server-5.1 or something... :-)

  • ShamliShamli Member
    edited August 2012

    here what i got...

    
    232703:~# dpkg-reconfigure mysql-server-5.1
    /usr/sbin/dpkg-reconfigure: mysql-server-5.1 is broken or not fully installed
    

    edit:

    and this I get when using force option...

    232703:~# dpkg-reconfigure -f mysql-server-5.1
    debconf: unable to initialize frontend: Mysql-server-5.1
    debconf: (Can't locate Debconf/FrontEnd/Mysql.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 24) line 2.)
    
    
  • gbshousegbshouse Member, Host Rep

    apt-get autoremove or apt-get purge mysql-client-core-5.5
    apt-get upgrade

  • still getting error...

    232703:~# apt-get autoremove
    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:
     mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not installed
    E: Unmet dependencies. Try using -f.
    232703:~# apt-get purge mysql-client-core-5.5
    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:
     mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not going to be installed
    E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
    
    
  • gbshousegbshouse Member, Host Rep
    edited August 2012

    apt-get install mysql-client-5.1
    and then
    apt-get install mysql-server-5.1

    you can also try cleaning packages first (but be careful)
    apt-get purge mysql*
    and
    apt-get install mysql-client-5.1 mysql-server-5.1

  • ShamliShamli Member
    edited August 2012

    also the same.

    232703:~# apt-get install mysql-client-5.1
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following package was automatically installed and is no longer required:
      mysql-client-core-5.5
    Use 'apt-get autoremove' to remove them.
    Suggested packages:
      libterm-readkey-perl
    The following NEW packages will be installed:
      mysql-client-5.1
    0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
    1 not fully installed or removed.
    Need to get 0 B/9587 kB of archives.
    After this operation, 22.9 MB of additional disk space will be used.
    (Reading database ... 44662 files and directories currently installed.)
    Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.63-0+squeeze1_i386.deb) ...
    dpkg: error processing /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb (--unpack):
     trying to overwrite '/usr/bin/mysqlcheck', which is also in package mysql-client-core-5.5 5.5.25a-1~dotdeb.1
    configured to not write apport reports
                                          dpkg-deb: subprocess paste killed by signal (Broken pipe)
    Errors were encountered while processing:
     /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    

    edit:

    cleaning also doesnt help...
    (apt-get purge mysql*)

    You might want to run 'apt-get -f install' to correct these:
    The following packages have unmet dependencies:
     phpmyadmin : Depends: php5-mysql but it is not going to be installed or
                           php5-mysqli but it is not installable
                  Recommends: mysql-client
    E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
    
  • gbshousegbshouse Member, Host Rep

    so run
    apt-get purge mysql*
    just remember to not remove the databases
    then make clean install
    apt-get install mysql-client-5.1 mysql-server-5.1

  • apt-get purge mysql*
    does nothing...

  • gbshousegbshouse Member, Host Rep

    hmmmm that's strange it should remove all packages starting with "mysql"
    are you sure that you need MySQL 5.1 not 5.5?
    You can also try to install Percona's version of MySQL

    if you want you can PM me the access data and I can try to login to your box and fix this for you

  • I'm trying to upgrade the server and the mysql to 5.5..then this happen...maybe it's time for me to clean up this server since it's initially installed with Debian 5....

    thanks for your support...=)

  • gbshousegbshouse Member, Host Rep

    if you are trying to upgrade to 5.5 why are you installing 5.1?
    Here you have Percona's documentation - their MySQL version is better then default one
    http://www.percona.com/doc/percona-server/5.5/installation.html
    just add the the repos to sources.list (http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html) and install
    apt-get update
    apt-get install percona-server-server-5.5

  • ShamliShamli Member
    edited August 2012

    before it's 5.1..then I upgrade it to 5.5,but something went wrong...and I dont know what's the wrong is....

    after many unsuccessfull attempt to continue upgrade,I try to revert back to 5.1...

    still,unsuccessfull...

    percona is something new to me...
    so,I'll need to stick with mysql for the moment and backup current database and do OS reinstallation...and maybe adding manually about 10+ domain and 40+ records...

  • gbshousegbshouse Member, Host Rep

    Percona is MySQL the only difference is that instead of default InnoDB they are using XtraDB. All configuration, management etc. is the same so don't be afraid

Sign In or Register to comment.