Hi All,
I'm getting things ready to upgrade my aging installation of MySQL 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 fast approaching my sense of doom and urgency is increasing.
I see that the necessary packages are available in @base and @updates - mysql51 and mysql55 respectively but from all the information I've read on the matter so far I'm left with a few questions I don't yet have answers to.'
What I've done so far and thankfully was able recover from:
1. installed and enabled to epel repo - ran yum remove mysql - this command wanted to remove a few things I wanted to keep in place like dovecot and a few php53 packages. I didn't want to have to go back and clean up any messes that would create. So, I used the rpm -e --nodeps command to remove the MySQL packages. - because this was a redhat repo it installed the binaries in a total different place AND tossed all my existing data directories. and yes I spit coffee all over my laptop screen and yes, I did have data dir backups and a dump of MySQL data. HOLY CRAP!
2. removed the epel packages - disabled this repo - for ever at least for now...
3. reinstalled the old MySQL 5.0.95 packages - because I was hyper-ventilating - reset roots password - imported all the databases from the dump and checked my web apps - everything working again. - I did have to recreate the mysql.servers table to be able to flush privileges.
I understand that mysql51 is available in @base for the sole purpose of upgrading old MySQL and mysql55 is in updates for getting to 5.5, however here is where things get a little fuzzy for me:
Steps for Upgrading (as I understand them):
1. Take a dump of all mysql database using mysqldump --add-drop-database --all-databases 2. Stop mysql services 3. make a backup of data directories: /var/lib/mysql (but its not _supposed_ to remove the data directories.) 3. yum remove mysql mysql-server (again, it will include a few things I don't want removed. so, i'll have to use rpm -e --nodeps and list the packages for removal then issue yum clean all.' 4. yum install mysql51 5. start mysql service 6. run command mysql_upgrade... (here's where things start getting fuzzy)
Question #1: is this command to be run from the commandline or should I log into mysql as root user and run the command?
Question #2: at this point I will have mysql 5.1 installed and running but to get up to 5.5 am I expected to yum remove 5.1 and then yum install 5.5 from @updates and repeat steps 5 and 6 OR simply run the command yum update mysql51* to catch all already installed mysql51 packages to and then run the mysql_update command to bring data up to date with the current mysql install?
THank you for your kind attention...