We are currently running production on ver 3.23. We have two db servers that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2 making it the new DB1 and then repeating the process with the old DB1 making it the new DB2. Here are my questions. Any known problmes with RH9.0 and MySQL 4.0? Our current 3.23 db uses MyISAM tables. I've read the "how to" on upgrading from 3.23 to 4.0 but I'm not really upgrading as much as "moving" the database to another server that just happens to be ver 4.0 instead of 3.23. If I do a On new server: # mysql create dbname On old server: # mysqldump dbname | mysql -h newserver dbname Will this take care of any table changes or will this cause problems? If I do things this way will I still need to run the mysql_fix_privilege_tables, mysql_convert_table_format etc? Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]