PDA

View Full Version : Upgrade to MySQL 5?

scotttam
12-20-2006, 10:17 PM
Has anyone upgraded their MySQL to 5.0 in their VPS instance?
Teej
12-21-2006, 04:31 PM
Its not possible if you want to continue using Plesk 8.0.1.

Plesk makes use of some SQL JOIN statements in MySQL 4.1.x that are interpreted differently in MySQL 5.x.
scotttam
12-22-2006, 12:39 PM
Actually, when I login to Plesk, it says:

"MySQL 5.0 support
Plesk 8.1 now fully supports MySQL 5.0, which is the latest stable version of this popular database engine."

So, it should work fine in theory.
JCR
12-22-2006, 08:52 PM
That is an interesting question. I'd like to know whether Plesk prevents us from installing most recent versions of PostgreSQL, Apache, PHP...

Maybe someone at gate.com could give us the qualified answers we are starving for.
Teej
12-23-2006, 10:23 AM
Plesk 8.1 does support MySQL 5, although by default with Fedora Core 4 MySQL 4.1.2 is installed.

It appears that existing VPSs have Plesk 8.0.x and new ones have Plesk 8.1. It is possible to upgrade from the control panel via Server > (Services) Updater.
scotttam
01-01-2007, 01:58 PM
Doesn't appear to be an option of a service to upgrade. I see postgres as an option.