The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Upgrade from Mysql 4.1 to Mysql5 unsuccesful

Discussion in 'General Discussion' started by InfiniteNetwork, Jan 23, 2008.

  1. InfiniteNetwork

    Joined:
    Jun 25, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canberra, Australia
    Hi everyone,

    I recently installed a new cPanel installation on a Freebsd 6.2 i386 server and the default install used Mysql 4.1. So I upgraded it to Mysql 5 by selecting Mysql 5 in the tweak settings and running /scripts/mysqlup

    Now this all seemed to work nicely and but after trying to import a database from another server we realised that the mysql database table structure is from 4.1 and not 5. This means stored procedures and some user table columns are not correct.

    Is there any particular script I can run to upgrade the mysql database to be the correct Mysql 5 format?

    Also what is the latest version of MySQL running on cPanel as mine is only 5.0.27 which seems quite old. Is there a list I can see to ensure the software is the right version that should be running on a FreeBSD cPanel installation?
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    On FreeBSD, MySQL is installed via the Ports system, hence is limited to whatever is the newest version in /usr/ports.

    As for the other problem, yes there is a script to fix the privilege tables, but I cannot recall what it is named. A google search might help, or lokking at all files/scripts that being with mysql.
     
  3. InfiniteNetwork

    Joined:
    Jun 25, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canberra, Australia
    Well thats what I thought but the latest version inside the ports directory is 5.0.51

    # $FreeBSD: ports/databases/mysql50-server/Makefile,v 1.228 2007/12/11 20:14:48 ale Exp $
    #

    PORTNAME?= mysql
    PORTVERSION= 5.0.51

    Any ideas? Does cpanel run a different version to ports?
     
  4. InfiniteNetwork

    Joined:
    Jun 25, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canberra, Australia
    Ok for everyone's info I have fixed the tables and columns missing after the upgrade, I ran the below instructions from the MySQL site and its all good, the reason why /scripts/mysqlup didn't do this I do not know.

    http://dev.mysql.com/doc/refman/5.0/en/mysql-fix-privilege-tables.html

    Still I don't know why it only uses 5.0.27 and 5.0.51 exists in the ports?
     
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What output do you get when you execute

    Code:
    /scripts/mysqlup --force --latest
    
    As for the permissions table script not running, I'll check the process to see what's happening therein.

    On a test server running FreeBSD 6.3, MySQL 5.0.45 is being used. When you checked the version available via ports, did you check on your local system or on FreeBSD's website?
     
  6. InfiniteNetwork

    Joined:
    Jun 25, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canberra, Australia
    This is my output

    [root@cpanel /home]# /scripts/mysqlup --force --latest
    MySQL Setup Script Version 7.0
    This is the MySQL installer for OS FreeBSD
    mysql-client-5.0 (5.0.27) is already installed.
    mysql-client-5.0 (5.0.27) is newer then requested version 5.0.27. (no install needed)
    mysql-server-5.0 (5.0.27) is already installed.
    mysql-server-5.0 (5.0.27) is newer then requested version 5.0.27. (no install needed)
    Install Complete

    I am unsure what you mean exactly. I took the output above from my ports collection under /usr/ports/databases/mysql50-server/Makefile
     
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  8. InfiniteNetwork

    Joined:
    Jun 25, 2003
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canberra, Australia
    Hi cpanelkenneth, this has been done.
     
Loading...

Share This Page