Some questions before I attempt to upgrade our mySQL 3.28 to 4.1 on our FC2 server with PSA 7.5.4.
Our server, thus far, has only had yum updates applied through the fedora legacy project.
I have now edited our yum.cnf file to include:
Code: Select all
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/$releasever/
It appears to connect just fine.
Question 1:
If I do the following, should all feasibly go smoothly with the mySQL upgrade, eliminate the old password problem, and have plesk continue to operate as it does now with just fedora legacy updates installed:
1. Dump all databases (currently only 2)
2. # yum remove mysql-server, rm -rf /var/lib/mysql
2. # yum update mysql* (is that the correct command?)
3. # run /usr/bin/safe_mysqld
4. Log onto plesk --> phpMyAdmin and re-create the databases and then re-import all the data from the old databases.
Would following those steps get this rookie up and running with mySQL 4.1, do away with the need to edit /etc/my.cnf with old_passwords=1, and keep plesk running as smooth as I have become accustomed to?
Question 2:
If something goes wrong, can I just -
# yum remove mysql-server, rm -rf /var/lib/mysql
take out:
Code: Select all
[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/art/$releasever/
[psa-7.5]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 7.5 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomic/psa-7.5/$releasever/
Thanks for any help or suggestions in advance.