[Bug 666383] Re: package mysql-server-5.1 5.1.41-3ubuntu12.6 failed to install/upgrade: [SRU] infinite loop in /etc/init/mysql.conf if mysqld is not running

[IAmDaveMyers]

Quick update.

Can confirm that the installation from source is running as expected.

Please note that if you are going to do this you need to find the folder
where your tables are kept (look into /usr/local/mysql/ data or they may
appear somewhere in a subfolder of /var/ ~ probably a personal setting.

a quick run down of what you need to bear in mind.

- make sure you have all your old data tables saved somewhere, and a
copy of your old my.cnf


- if you are running some systems (eg drupal) they look for the mysql.sock file in a different location (ie not /tmp/mysql.sock) so you will need to create a symbolic link to the file for them to work, I assume that in the deb install / upgrade this not an issue?

- As you are installing from source you will need to insert mysql into
/etc/init.d/ if you want it to run on boot up.

- to do this you need to run the following commands...

get chkconfig, as it isn't included in the newer version, as they are using upstart and not system-v init.d things.
   sudp apt-get install chkconfig

the server start up script needs to be in the correct location...

   sudo cp /usr/local/mysql/mysql.server /etc/mysql

now you can insert mysql into the init.d

   sudo chkconfig --add mysql

and tell the server to run mysql at boot

   sudo update-rc.d mysql defaults

You will get error messages about the script now being an upstart job.

This worked for me, hope it works for someone else also...

I've put this procedure on the ubuntu forums  ~  http://ubuntuforums.org/newreply.php?do=newreply&noquote=1&p=9951303
so if there are any questions / changes, please contact me there, here, or via pm.

David

-- 
package mysql-server-5.1 5.1.41-3ubuntu12.6 failed to install/upgrade: [SRU] infinite loop in /etc/init/mysql.conf if mysqld is not running
https://bugs.launchpad.net/bugs/666383
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.