Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: MySQL 9.04. > 9.10 problem

  1. #11
    Join Date
    Apr 2007
    Beans
    9

    Re: MySQL 9.04. > 9.10 problem

    I also have the same problem,

    For me, it solved:

    1.- renaming my.cnf
    2.- #aptitude reinstall mysql
    3.- restoring my.cnf
    4.- removing 'bind-address' option of my.cnf
    5.- #service mysql restart


  2. #12
    Join Date
    Aug 2006
    Beans
    2

    Re: MySQL 9.04. > 9.10 problem

    After struggling with it for a LONG time, playing with apparmor setting etc., I had to go all the way; removing mysql-server & mysql-common with purge option (+OpenOffice etc. dependencies).

    Also had to rm -r /etc/mysql , /var/lib/mysql , /var/log/mysql
    and after all this, reinstall all. Finally, Ubuntu managed to create a new my.cnf under /etc/mysql .
    Database started up nicely, and I noticed the weirdest thing:
    after seeing the error at mysql startup
    "/etc/init.d/mysql: line 123: /etc/mysql/debian-start: No such file or directory"
    I realised that the complete reinstall made the /etc/mysql/debian-start disappear, and suddenly everything works.
    I suppose that file had not been properly updated in the upgrade from 9.04 -> 9.10 .
    Next time: fresh install to 10.04 ...

  3. #13
    Join Date
    May 2009
    Location
    North West England
    Beans
    2,675
    Distro
    Ubuntu Development Release

    Re: MySQL 9.04. > 9.10 problem

    Quote Originally Posted by vikonen View Post
    After struggling with it for a LONG time, playing with apparmor setting etc., I had to go all the way; removing mysql-server & mysql-common with purge option (+OpenOffice etc. dependencies).

    Also had to rm -r /etc/mysql , /var/lib/mysql , /var/log/mysql
    and after all this, reinstall all. Finally, Ubuntu managed to create a new my.cnf under /etc/mysql .
    Database started up nicely, and I noticed the weirdest thing:
    after seeing the error at mysql startup
    "/etc/init.d/mysql: line 123: /etc/mysql/debian-start: No such file or directory"
    I realised that the complete reinstall made the /etc/mysql/debian-start disappear, and suddenly everything works.
    I suppose that file had not been properly updated in the upgrade from 9.04 -> 9.10 .
    Next time: fresh install to 10.04 ...
    Next Time, tasksel

    http://forum.phillw.net/viewtopic.php?f=4&t=4

    Although, my LAMP from 9.04 --> 9.10 went sweet.

    You know it makes sense

    Regards,

    Phill.
    Last edited by phillw; March 22nd, 2010 at 07:18 PM.

  4. #14
    Join Date
    Nov 2005
    Beans
    140
    Distro
    Ubuntu 6.06

    Re: MySQL 9.04. > 9.10 problem

    Quote Originally Posted by cabez0n View Post
    I simply started removing option from my.cnf until it came up.
    I found out that skip-bdb is not a valid option anymore, and it was there by default on previous mysqls so you might want to delete that one.
    Thank you! This did it for me!

  5. #15
    Join Date
    May 2007
    Beans
    1

    Re: MySQL 9.04. > 9.10 problem

    Quote Originally Posted by cabez0n View Post
    I simply started removing option from my.cnf until it came up.
    I found out that skip-bdb is not a valid option anymore, and it was there by default on previous mysqls so you might want to delete that one.
    I followed the recommendation above, but it still didn't work for me. I ended up with a different message along the lines of:

    --------------------------------------------------------------------------
    ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
    --------------------------------------------------------------------------

    I saved a copy of my functioning my.cnf file prior to the update, and I DIFFed it with the new one from Karmic. My findings proved that commenting out:

    --------------------------
    #myusam-recover = BACKUP
    --------------------------

    was ALSO necessary.

  6. #16
    Join Date
    Jan 2010
    Location
    Toms River, NJ
    Beans
    6
    Distro
    Ubuntu 10.10 Maverick Meerkat

    Re: MySQL 9.04. > 9.10 problem

    Quote Originally Posted by Socawarrior View Post
    I followed the recommendation above, but it still didn't work for me. I ended up with a different message along the lines of:

    --------------------------------------------------------------------------
    ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
    --------------------------------------------------------------------------

    I saved a copy of my functioning my.cnf file prior to the update, and I DIFFed it with the new one from Karmic. My findings proved that commenting out:

    --------------------------
    #myusam-recover = BACKUP
    --------------------------

    was ALSO necessary.
    This worked for me, but I should note you have it mis-spelled.

    So, for the newcomers... to fix this, comment off these 2 lines in /etc/mysql/mysql.cnf then reboot:
    skip-bdb
    myisam-recover = BACKUP

  7. #17
    Join Date
    Jul 2010
    Beans
    1

    Re: MySQL 9.04. > 9.10 problem

    I tried the recommendations about "my.cnf" and didn't work. I not tried to remove mysql-common because of all dependencies that needs to be removed too.

    So, I opened the Synaptic Package Manager and saw that was installed "mysql-server-core-5.1", but not the "mysql-server-5.1".
    I marked "mysql-server-5.1" for installation and that was an advice that "mysql-server-5.0" should be removed before install the 5.1

    Well, I installed mysql-server-5.1, removed mysql-server-5.0 and mysql worked fine after reboot.

Page 2 of 2 FirstFirst 12

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •