Tuesday, March 10, 2015

Upgrading MySQL Server.

Follow the below steps to upgrade MySQL Server to a newer version.
  1. First take the backup of all databases in the present MySQL Server.
  2. Remove the MySQL Server Installed in the server.
  3. Download the new RPM/Binary Packages from http://www.mysql.com/downloads
  4. Install the packages in the Server.
  5. Give the permissions to the server i.e., /var/lib/mysql folder.
  6. Run mysql_upgrade
  7. Now Restore the databases on the server.
  8. Now check the server whether all the database tables have been on the server.

No comments:

Post a Comment