Difference between revisions of "Mysql"

Revision as of 07:21, 23 June 2010 (edit) Scott (Talk | contribs) (→‎Installation) ← Older edit		Revision as of 06:48, 29 June 2010 (edit) (undo) Scott (Talk | contribs) Newer edit →
Line 42:		Line 42:
	== Known Issues ==		== Known Issues ==
−	Placeholder	+
		+
		+	== 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 -p''youradminpassword''
		+
		+	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:
		+
		+	[http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html] http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
		+
		+	[http://forum.parallels.com/pda/index.php/t-85461.html] http://forum.parallels.com/pda/index.php/t-85461.html

---

Revision as of 06:48, 29 June 2010

Contents 1 Features 2 Installation 3 Support Packages 4 Known Issues 5 Problems with MySQL databases and PLESK 9 after upgrade

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

[2] http://forum.parallels.com/pda/index.php/t-85461.html