Error when upgrading MySQL

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...

AhmadShamli
Get Free 25GB backup storage here https://copy.com?r=YAYUHD

Comments

  • It look like you have newer client version already installed

  • already tried a dpgk-reconfigure ?

    http://www.de-punkt.de - a german vps hosting company since 1996

  • 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...

    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • @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
    
    
    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • @Shamli ofcourse you need the exact name of the package...f.e. mysql-server-5.1 or something... :-)

    http://www.de-punkt.de - a german vps hosting company since 1996

  • 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.)
    
    
    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • 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).
    
    
    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • gbshousegbshouse Member
    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).
    
    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • 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...

    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • 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...=)

    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • 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...

    AhmadShamli
    Get Free 25GB backup storage here https://copy.com?r=YAYUHD
  • 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.