How to upgrade MySQL 3.23 to 4.0 ???

Yes, I am still running 3.23. I know it is time to upgrade, but I am still hesitant because I don't want to break anything or mess up any databases. I have read various posts on different forums, some saying it is easy and some saying that they had major problems. I am currently running RHEL 3 with NO panel. Below are some quotes I have taken from various boards:


"You can download the RPM's for MySQL at php.net and just run an RPM -Uvh *.rpm on just the MySQL RPM's (to whatever version you're upgrading to). Regardless, it's very, very simple and when you upgrade it will spit out the couple of commands for you that you need to run (it tells you and you can just pretty much copy and paste them)."


"I would reccomend you run a 'mysql-dump --opt -A > mysql-backup.sql' before you do any upgrade.
It's always best to have a good backup before you attempt ANY type of upgrade. Unless you don't care about your MySQL data...
But after you get a good backup, go grab the RPM's, do a 'rpm -Uvh <rpm file name>' then a 'mysql_fix_<script name>' to fix various upgrade diff's between versions."


"Log in via ssh and type /scripts/sysup then /scripts/updatenow then /scripts/mysqlup"


Can anyone confirm these steps above?

From what I have gathered, it is obviously best to back up my databases first. Should I do a mysql dump, or can I simply copy /var/lib/mysql as a back-up?

Next, I'll want to grap the rpm's for 4.0. Where should I get them? Where should I put them? What command should I run to install them? Should I stop mysql when doing this?

I guess the last step would be to make sure my databases still work. One of the quotes above says that I'll have to run a few commands to update the databases/tables. What are these exact commands?

http://dev.mysql.com/doc/mysql/en/up...from-3-23.html has the steps to upgrade, but it seems a little overwhelming.

If anyone could provide me the step-by-step to upgrading or point me to a thread that has the instructions for upgrading on a box with NO panel I would greatly appreciate it.

Thanks,

 

 

 

 

Top