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.
Apt-get upgrade broke MySQL
Just did an apt-get update && apt-get upgrade on Debian 7 and now it's saying
Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ... [ ok ] Stopping MySQL database server: mysqld. [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)
I tried dpkg-reconfigure mysql-server-5.5 but it just says /usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed
It was working fine before I upgraded, now I can't get MySQL to start at all.
Comments
@hostnoob - Try apt-get dist-upgrade
apt-get --reinstall install mysql-server
If the other suggestions don't work, you can also try using aptitude instead of apt-get. It often handles conflicts better than apt-get.
Check MySQL error log, fix the error, and run "apt-get -f install"
default-storage-engine = myisam
Stick that in your mysql conf
Mysql not installed properly in the firstplace
A missing option could be the reason to prevent starting and cause an unfinished installation.
Try to remove MySQL
Then install again
can you show your source.list? i had this same issue when i would do a fresh install, install dotdeb repos, then do an install from apt-get for mysql-server. Just curious.
thanks for the replies guys, will try some out now
it was installed properly before and working fine. here's my sources.list
Okay I sorted it now. raj was pretty close.
I moved my my.cnf file out of /etc/mysql/ then upgraded it, moved the cnf file back and restarted and it's working fine now
had the exact same problem last wednesday... Almost had a heart attack lol. I was actually thinking about switching to mariadb... Took the opportunity to do it and couldn't be happier