Upgrade from Mysql 4.1 to Mysql5 unsuccesful

[InfiniteNetwork]

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?

[cpanelkenneth]

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.

[InfiniteNetwork]

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?

[InfiniteNetwork]

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/...ge-tables.html

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

[cpanelkenneth]

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/...ge-tables.html

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

What output do you get when you execute

/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?

[InfiniteNetwork]

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

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?

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

[cpanelkenneth]

Would you mind opening a complimentary support ticket at https://tickets.cpanel.net/submit/ ?

Mark it ATTN: QA MySQL

Thanks.

[InfiniteNetwork]

Hi cpanelkenneth, this has been done.