Upgrade Mysql on Plesk CentOS Linux

We had successfully upgraded from Mysql 5.0 to Mysql 5.1.47 along with PHP on one of our plesk server. Please use this solution if you notice any package conflicts, or other concerns with using 5.1 in your environment. Like PHP, this will be a full change to the newer packages and the 5.0 series will be retired. The procedure is quite simple

1.) wget -q -O – http://www.atomicorp.com/installers/atomic.sh | sh

2.)  To upgrade:

yum –enablerepo=atomic-testing upgrade mysql

Thats it,  And if you simply want to upgrade php run “yum upgrade php”

With the above methods mysql will be upgraded to latest release without any problems.

Upgrade Mysql on Plesk CentOS Linux

We had successfully upgraded from Mysql 5.0 to Mysql 5.1.47 along with PHP on one of our plesk server. Please use this solution if you notice any package conflicts, or other concerns with using 5.1 in your environment. Like PHP, this will be a full change to the newer packages and the 5.0 series will be retired. The procedure is quite simple

1.) wget -q -O – http://www.atomicorp.com/installers/atomic.sh | sh

2.)  To upgrade:

yum –enablerepo=atomic-testing upgrade mysql

Thats it,  And if you simply want to upgrade php run “yum upgrade php”

With the above methods mysql will be upgraded to latest release without any problems.

PHP Warning: Unknown: POST Content-Length of 28 bytes exceeds the limit of -2147483648 bytes in Unknown on line 0

If you are noticing the above error in apache error logs and having problems for login scripts the problem is with post_max_size variable in php.ini

Here is what you need to do, Find out the correct php.ini configuration file.

root@server [/usr]# php -i | grep php.ini

Configuration File (php.ini) Path => /usr/local/lib
Loaded Configuration File => /usr/local/lib/php.ini

Edit the loaded php.ini file and check for post_max_size variable value, Set it to 8M which is best recommended.

root@server [/usr]# grep post_max /usr/local/lib/php.ini

post_max_size = 8M

Then restart apache, That should resolve the problem.

PHP Warning: Unknown: POST Content-Length of 28 bytes exceeds the limit of -2147483648 bytes in Unknown on line 0

If you are noticing the above error in apache error logs and having problems for login scripts the problem is with post_max_size variable in php.ini

Here is what you need to do, Find out the correct php.ini configuration file.

root@server [/usr]# php -i | grep php.ini

Configuration File (php.ini) Path => /usr/local/lib
Loaded Configuration File => /usr/local/lib/php.ini

Edit the loaded php.ini file and check for post_max_size variable value, Set it to 8M which is best recommended.

root@server [/usr]# grep post_max /usr/local/lib/php.ini

post_max_size = 8M

Then restart apache, That should resolve the problem.