Results 1 to 8 of 8

Thread: Upgarde to mysql 5.1

  1. #1
    Join Date
    Mar 2007
    Posts
    94

    Upgarde to mysql 5.1

    Hi,

    I have upgraded to 5.1 and when I CB finished I get this:

    Code:
    mysql-5.1.30-freebsd6.2-i386.tar.gz created
    Removing temporary directory
    Moving mysql-5.1.30-*.tar.gz to main direcotry...
    done.
    Stopping mysqld ...
    Stopping mysqld:		[ OK ]
    Installing mysql-5.1.30-freebsd6.2-i386.tar.gz...
    Starting mysqld:		[ OK ]
    Giving mysqld a few seconds to start up...
    Looking for 'mysql' as: /usr/local/mysql/bin/mysql
    Looking for 'mysqlcheck' as: /usr/local/mysql/bin/mysqlcheck
    Running 'mysqlcheck'...
    /usr/local/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed
    Done mysql-5.1.30-freebsd6.2-i386.
    Restarting MySQL.
    Stopping mysqld:		[ FAILED ]
    Starting mysqld:		[ OK ]
    It is recommended to do "./build php n" after MySQL update.
    I have FreeBSD 6.2, CB 1.2.11

    My options.conf
    Code:
    #Possible values - 5.0, 5.1
    mysql=5.1
    mysql_inst=yes
    mysql_backup=yes
    Thanks

  2. #2
    Join Date
    Aug 2008
    Posts
    4,697
    Are you sure mysql actually started?

    ps xua | grep -i mysql | grep -v grep

  3. #3
    Join Date
    Mar 2007
    Posts
    94
    [root@s1 /var]# ps xua | grep -i mysql | grep -v grep
    [root@s1 /var]# /usr/local/etc/rc.d/mysqld start
    Starting mysqld: [ OK ]
    [root@s1 /var]# ps xua | grep -i mysql | grep -v grep
    [root@s1 /var]#

    Also if I try to start it from DA it is the same.

  4. #4
    Join Date
    Aug 2008
    Posts
    4,697
    There has gotta be a reason it is not starting. Check /var/log/messages for any errors. You might have to turn on mysql debugging to be able to see any errors.

  5. #5
    Join Date
    Mar 2007
    Posts
    94
    How I can turn on debug for mysql? Recompile??

  6. #6
    Join Date
    Aug 2008
    Posts
    4,697
    Run the following command then restart mysql as normal. Then see if there are errors in /var/log/messages

    Code:
    perl -pi -e 's/\/usr\/local\/mysql\/bin\/mysqld_safe --user/\/usr\/local\/mysql\/bin\/mysqld_safe --log-error=\/var\/log\/messages --user/' /usr/local/etc/rc.d/mysqld

  7. #7
    Join Date
    Mar 2007
    Posts
    94
    Ok, I found log It is in /home/mysql :P Didn't know that.

    Code:
    [root@s1 /usr/local/mysql/data]# /usr/local/etc/rc.d/mysqld start
    Starting mysqld:		[ OK ]
    [root@s1 /usr/local/mysql/data]# tail s1.xxx.xx.err 
    090127 20:50:11 mysqld_safe mysqld from pid file /usr/local/mysql/data/s1.pid ended
    090127 20:50:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
    /usr/local/mysql-5.1.30-freebsd6.2-i386/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    090127 20:50:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    090127 20:50:12 [ERROR] /usr/local/mysql-5.1.30-freebsd6.2-i386/libexec/mysqld: unknown option '--skip-innodb'
    090127 20:50:12 [ERROR] Aborting
    
    090127 20:50:12 [Note] /usr/local/mysql-5.1.30-freebsd6.2-i386/libexec/mysqld: Shutdown complete
    
    090127 20:50:12 mysqld_safe mysqld from pid file /usr/local/mysql/data/s1.pid ended
    I have tried to run mysql_upgrade but:

    Code:
    [root@s1 /usr/local/mysql/bin]# ./mysql_upgrade 
    Looking for 'mysql' as: ./mysql
    Looking for 'mysqlcheck' as: ./mysqlcheck
    Running 'mysqlcheck'...
    ./mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed
    Any tip?

    Thanks

  8. #8
    Join Date
    Aug 2008
    Posts
    4,697
    haha I have no clue how you will be able to do that if the stupid server wont start.

Similar Threads

  1. Replies: 23
    Last Post: 03-13-2012, 11:28 PM
  2. build mysql d > wont work - mysql dead
    By Tim in forum MySQL / PHP
    Replies: 12
    Last Post: 08-31-2011, 10:40 AM
  3. Replies: 2
    Last Post: 12-17-2008, 07:04 PM
  4. Replies: 4
    Last Post: 10-20-2007, 11:20 AM
  5. how to upgarde ftp, dns, exim
    By meocon in forum General Technical Discussion & Troubleshooting
    Replies: 1
    Last Post: 08-16-2005, 05:17 PM

Posting Permissions

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