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