Mysql – Upgrading thesql 5.0 to thesql 5.1

MySQL

I need to upgrade mysql 5.0 to mysql 5.1.
Do i need to carry out anymore steps then these.

I will log into the server and do
rpm -Uvh MySQL-server-community-5.1.63-1.rhel5.x86_64

the earlier version of mysql was installed using yum install .

Is this the correct approach ?
After installing do i need to upgrade the indvidual database themselves if so how ?

regards

Best Answer

As usual before such operations, back up your databases. You can use:

mysqldump --add-drop-database --all-databases

Your approach should be sufficient, but if not, you'll be able to restore everything in a clean way.

Edit: and you can refer to the MySQL documentation on the subject.

Related Topic