Difference between revisions of "Mysql"

From Atomicorp Wiki
Jump to: navigation, search
(Installation)
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 07:48, 29 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

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

Personal tools