a.kao

I attempted to upgrade MySQL server from old version 3.23.58 to 4.1 current. Amazingly everything is workingafter the upgrade and the whole site feels more responsive. I installed it directly off the MySQL website since I cannot find fc2 rpm for yum to upgrade.

Steps I took to get this done:

• 1. Backup EVERYTHING!
• 2. Download MySQL source directly from MySQL
• 3. Untar mysql tar ball
• tar xvzf mysql-4.1-xxx.tar.gz
• 4. Copy/Move entire mysql-4.1-xxx directory to /usr/local
• 5. Setup directory permission
• chown -R root .
chown -R mysql data/
chgrp -R mysql .

• 6. Created symbolic link for MySql directory
• ln -s mysql-4.1-xxx/ mysql
• 7. Copy my-medium.cnf from /usr/local/mysql/support-files and merged with my existing my.cnf
• 8. In the new my.cnf, changed [safe_mysqld] section name to [mysqld_safe]. I also made sure datadir is pointing to my existing database location
• 9. Corrected all path under /etc/init.d/mysqld startup script
• 10. start mysqld_safe - /usr/local/mysql/bin/mysqld_safe
• 11. fix privilege table by running mysql_fix_privilege_tables scripts from the /usr/local/mysql/bin
• 12. Checked websites, phpmyadmin and mysql users. It seems all information were retained

If any experience admin read this and found error or things I shouldn’t do. Please let me know. :)