Mysql
From Atomicorp Wiki
Contents |
Features
- Based on Mysql 5.1.x branch
- Uses the design from Fedora, RHEL, and CentOS
Installation
To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora
Step 1) Set up the atomic channel:
wget -q -O - http://www.atomicorp.com/installers/atomic | sh
Step 2) Upgrade to Mysql 5.1
yum upgrade mysql
Step 3) Update /etc/my.cnf, the following token has been deprecated and must be removed
skip-bdb
Step 4) Update your mysql tables
mysql_upgrade -u root -p
or for plesk environments:
mysql_upgrade -u admin -p
Step 5) Restart mysql
/etc/init.d/mysqld restart
Support Packages
Mysqltuner, an excellent tool for investigating performance issues with mysql
yum install mysqltuner
Known Issues
Problems with MySQL databases and PLESK 9 after upgrade
If you get the following error after upgrading when you try to log into PLESK then you need to upgrade your database tables:
ERROR: PleskFatalException bad column in table: `backup_time` time NOT NULL default '00:00:00', [...]
Issue the following command from the shell:
mysqlcheck --check-upgrade --all-databases --auto-repair -uadmin -pyouradminpassword
followed by:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=admin --password=youradminpassword --host=localhost --database=mysql
This script updates all the mysql privilege tables to be usable by the current version of MySQL.
References:
[1] http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
