Hi
I have my production server running mysql5 for few days with this methode. it works great and with php 4.3.9-3.15.
What i could add is :
-i didn't need to grant the mysql rights for the webmail it was ok for me.
-i would add another thing a new table is necessary for mysql 5 so you will have to add it manually (if you forgot it, it may works, but it's better to have a clean install):
So here the complete how to :
mysqldump -aec >mondump.sql
/etc/rc.d/init.d/mysql stop
yum --enablerepo=centosplus update mysql
/etc/rc.d/init.d/mysql start
And if the webmail has no access to the data :
mysql -e "GRANT SELECT,INSERT,UPDATE,DELETE ON horde.* TO 'horde'@'localhost';FLUSH PRIVILEGES"
Finaly:
-- MySQL dump 10.10
--
-- Host: localhost Database: mysql
-- ------------------------------------------------------
-- Server version 5.0.22
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table proc
--
DROP TABLE IF EXISTS proc;
CREATE TABLE proc (
db char(64) character set utf8 collate utf8_bin NOT NULL default ,
name char(64) NOT NULL default ,
type enum('FUNCTION','PROCEDURE') NOT NULL,
specific_name char(64) NOT NULL default ,
language enum('SQL') NOT NULL default 'SQL',
sql_data_access enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL',
is_deterministic enum('YES','NO') NOT NULL default 'NO',
security_type enum('INVOKER','DEFINER') NOT NULL default 'DEFINER',
param_list blob NOT NULL,
returns char(64) NOT NULL default ,
body longblob NOT NULL,
definer char(77) character set utf8 collate utf8_bin NOT NULL default ,
created timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
modified timestamp NOT NULL default '0000-00-00 00:00:00',
sql_mode set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE') NOT NULL default ,
comment char(64) character set utf8 collate utf8_bin NOT NULL default ,
PRIMARY KEY (db,name,type)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';