How to upgrade Mysql with Plesk 8.01

[Phillip Chapman]

I have a VPS with Data393 running Plesk 8.01, Mysql 3.23.58 and PHP 4.38.

I'd like to update Mysql in order to make my specs compliant with the latest version of vBulletin. I have never updated Mysql or PHP before, so I need explicit step-by-step instructions on how to perform a Mysql update to ensure this goes flawlessly. Data393 wouldn't update Mysql without a charge of around $60-$70. They estimated it would take up to 45 minutes for them to update Mysql.

I can log in as root to my VPS and also through Plesk 8.01 obviously. Please let me know what stable version of Mysql we should upgrade to and exactly how to perform the upgrade.

Thanks in advance for any help and step-by-step instructions that you can provide.

[Steve Machol]

Wrong forum. Moved to Server Configuration.

[eva2000]

plesk has specific needs for how to properly update php/mysql and apache.. unfortunately i'm not familiar with them for plesk.

The best way is to either

1. ask on plesk.com support forums, ev1servers.net support forums and webhostingtalk.com also have alot of plesk administrators and users you can ask

2. get web host to do the upgrade for the price - probably easiest and simplest way.. as you'd end up paying them to fix things if you screw up manually doing the upgrade yourself.

I recommend PHP 4.4.4 and if you're going from MySQL 3.23.58, upgrade to MySQL 4.0.27 first see important notes at http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html then upgrade from 4.0.27 to MySQL 4.1.21 http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html

Mysql recommends that you do incremental upgrades between major versions and not to skip them i.e. don't upgrade straight from 3.23.58 to 4.1.21 as you could introduce incompatibility between mysql database table structures.

Always remember to backup your databases using mysqldump before upgrading! So make backup before upgrading from 3.23.58 to 4.0.27, make a 2nd backup before upgrading from 4.0.27 to 4.1.21.