Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

After upgrade to 12.04 mysql server was unable to start.

I tried many different things but without any luck.

Now when I try to install it, I get:

$  sudo apt-get install mysql-server-5.5
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server-5.5
0 upgraded, 1 newly installed, 0 to remove and 39 not upgraded.
Need to get 0 B/8,708 kB of archives.
After this operation, 31.3 MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 243325 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.22-0ubuntu1_i386.deb) ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
ureadahead will be reprofiled on next reboot
Setting up mysql-server-5.5 (5.5.22-0ubuntu1) ...
120509 20:32:08 [Note] Plugin 'FEDERATED' is disabled.
120509 20:32:08 InnoDB: The InnoDB memory heap is disabled
120509 20:32:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120509 20:32:08 InnoDB: Compressed tables use zlib 1.2.3.4
120509 20:32:08 InnoDB: Initializing buffer pool, size = 128.0M
120509 20:32:08 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
120509 20:32:09 [ERROR] Plugin 'InnoDB' init function returned error.
120509 20:32:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120509 20:32:09 [ERROR] Unknown/unsupported storage engine: InnoDB
120509 20:32:09 [ERROR] Aborting

120509 20:32:09 [Note] /usr/sbin/mysqld: Shutdown complete

start: Job failed to start
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
Errors were encountered while processing:
 mysql-server-5.5
E: Sub-process /usr/bin/dpkg returned an error code (1)

Can someone suggest some way to fix this or I must to reinstall entire system?

Thanks in advance.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Reinstalling your complete system is not needed. If anything you can always do

sudo apt-get remove --purge mysql-server
sudo apt-get install mysql-server-5.5

Things that happend when I installed mysql and ran into trouble:

  • It is possible your missing or have a corrupt /etc/my.cnf (see the message about a problem in .cnf?). If so ...

    sudo mv /etc/mysql/my.cnf  /etc/mysql/my.cnf.old 
    sudo cp /etc/mysql/my.cnf.dpkg-old /etc/mysql/my.cnf
    /etc/init.d/mysql start
    

    Ofcourse do 1st check if you have a my.cnf.dpkg.dist

share|improve this answer
1  
Thank you very much for your quick response, really appreciate it. Here is what I got gist.github.com/548158a51643a9ddc78a :( BTW, I have no /etc/mysql/my.cnf.dpkg-dist, here is what I have gist.github.com/813c6b5164a9d50e2fb3, my.cnf.dpkg-old probably. –  umpirsky May 9 '12 at 19:41
1  
I replaced my.cnf with my.cnf.dpkg-old and it did the trick, thanks a bunch! –  umpirsky May 9 '12 at 19:47
    
I don't have any file called my.cnf. What should I do? –  user62330 May 10 '12 at 11:38
    
What do you have in /etc/mysql? –  umpirsky May 10 '12 at 11:46
    
@indigon could be... it could also be on a totally different location. Default it is in /etc/mysql. There should also be a default there (see the answer for the name ;) ) –  Rinzwind May 10 '12 at 13:27

That answer is hugely dangerous to anyone that has mysql databases, as it will delete all of them. And it is not necessary to perform such a procedure. Simply do:

sudo touch /etc/apparmor.d/local/usr.sbin.mysqld
service mysqld start

And mysql will return to normal state, mysql will be running and your databases will end alive not erased..

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.