Difference between revisions of "Mysql"
From Atomicorp Wiki
(→Installation) |
|||
| Line 18: | Line 18: | ||
yum upgrade mysql | yum upgrade mysql | ||
| − | Step 3) Update your mysql tables | + | 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 | mysql_upgrade -u root -p | ||
| Line 26: | Line 31: | ||
mysql_upgrade -u admin -p | mysql_upgrade -u admin -p | ||
| − | + | Step 5) Restart mysql | |
| + | /etc/init.d/mysqld restart | ||
== Support Packages == | == Support Packages == | ||
Revision as of 07:21, 23 June 2010
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
Placeholder
