Update from MySQL 5.1 to MySQL 5.5

The procedures in this section describe how to update from MySQL 5.1 to MySQL 5.5.

How to Update to MySQL 5.5 Before Updating Your System To Oracle Solaris 11.2

1. Install the MySQL 5.5 package.

   # pkg install database/mysql-55@latest

2. Verify if the mysql service is running.

   # svcs -a | grep mysql

3. Start the MySQL 5.1 service if the service is not already running.

   # svcadm enable svc:/application/database/mysql:version_51

4. Back up the MySQL 5.1 data.

   # mysqldump --all-databases > 5_1.sql

5. Stop the MySQL 5.1 service and start the MySQL 5.5 service.

   # svcadm disable svc:/application/database/mysql:version_51

   # svcadm enable svc:/application/database/mysql:version_55

6. Restore the backup data from MySQL 5.1.

   # mysql < 5_1.sql

How to Update to MySQL 5.5 After Updating Your System To Oracle Solaris 11.2

1. Install the MySQL 5.5 package.

   # pkg install mysql55

2. Stop the MySQL 5.1 service.

   # svcadm disable svc:/application/database/mysql:version_51

3. Copy the database files to a new directory.

   # cp /var/mysql/5.1/data/*.db /var/mysql/5.5/data/*.db

4. Start the MySQL 5.5 service.

   # svcadm enable svc:/application/database/mysql:version_55

5. Run the mysql_upgrade script to fix any database incompatibilities.

   # /usr/mysql/5.5/bin/mysql_upgrade