Mysql error after upgrade from squeeze to wheezy

````
root@ginger:~# apt-get install mysql-client
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.5 : Depends: mysql-client-5.5 (>= 5.5.31+dfsg-0+wheezy1) but 5.5.30-1~dotdeb.0 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
root@ginger:~#

I can't seem to remove that package either when I try to remove I get the same dependency errors. I had the dotdeb.org packages in my sources.list but removed them and still the same problem. Can't remove or install mysql. And when I try to start it I get.

root@ginger:~# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@ginger:~#

Trying to remove results in :

root@ginger:~# apt-get remove --purge mysql-server
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.5 : Depends: mysql-client-5.5 (>= 5.5.31+dfsg-0+wheezy1) but 5.5.30-1~dotdeb.0 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

Finally the error i get which might be more helpful.

root@ginger:~# apt-get -f install mysql-client-5.5
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following packages were automatically installed and are no longer required:
libfont-freetype-perl libfontenc1 libgmp3c2 libgsf-1-114 libgsf-1-common libpython2.6 libxcb-render-util0 libxfont1 mysql-client-core-5.5 xfonts-encodings
xfonts-utils
Use 'apt-get autoremove' to remove them.
Suggested packages:
libterm-readkey-perl
The following packages will be upgraded:
mysql-client-5.5
1 upgraded, 0 newly installed, 0 to remove and 130 not upgraded.
178 not fully installed or removed.
Need to get 0 B/1,923 kB of archives.
After this operation, 6,752 kB of additional disk space will be used.
Reading changelogs… Done
(Reading database … 36477 files and directories currently installed.)
Preparing to replace mysql-client-5.5 5.5.30-1~dotdeb.0 (using …/mysql-client-5.55.5.31+dfsg-0+wheezy1amd64.deb) …
Unpacking replacement mysql-client-5.5 …
dpkg: error processing /var/cache/apt/archives/mysql-client-5.55.5.31+dfsg-0+wheezy1amd64.deb (--unpack):
trying to overwrite '/usr/bin/mysqlcheck', which is also in package mysql-client-core-5.5 5.5.30-1~dotdeb.0
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
Errors were encountered while processing:
/var/cache/apt/archives/mysql-client-5.55.5.31+dfsg-0+wheezy1amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@ginger:~#

````

Any idea what I can do? I want to either fix the current mysql installation or remove it all together and reinstall.

Thanks

2 Replies

Are you sure you were using the dotdeb repo for Wheezy? It can be easy to forget one little detail like that when upgrading.

Looks like MySQL is already running. Look in /var/run to see if anything related to MySQL is there. If so, try to backup your databases with:

mysql -u root -p --databases some_database > some_database_backup.sql

Replace some_database above with an actual database.

If all your repos are in order, and you still can't upgrade, you will need to force removal of MySQL using the dpkg command:

dpkg --force-depends -r mysql-server mysql-client && apt-get -f install && apt-get install mysql-server mysql-client

In order: dpkg will remove mysql ignoring dependencies, apt-get will install whatever necessary to fix broken/missing dependencies, then apt-get will install mysql.

Hi Piki,

I was able to resolve it by doing.

apt-get -f install -o Dpkg::Options::="--force-overwrite"

And followed by :

apt-get remove –purge mysql\*
rm -rf /var/lib/mysql
rm -rf /etc/mysql
dpkg -l | grep -i mysql
apt-get clean
updatedb
apt-get install mysql-client mysql-client-5.5 mysql-common mysql-server-5.5

Made a backup of my database before of course.

The problem had something to do with mixin dotdeb.org repos and debian.

More info here : http://www.dotdeb.org/2013/05/05/debian … -released/">http://www.dotdeb.org/2013/05/05/debian-7-0-wheezy-has-been-released/

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct