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.
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
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
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
@Shamli ofcourse you need the exact name of the package...f.e. mysql-server-5.1 or something... :-)
here what i got...
edit:
and this I get when using force option...
apt-get autoremove or apt-get purge mysql-client-core-5.5
apt-get upgrade
still getting error...
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
also the same.
edit:
cleaning also doesnt help...
(apt-get purge mysql*)
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...
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...=)
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
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...
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