3 - Upgrading the Database

If you've made changes to the Elastic Path database schema, depending how those changes were applied, some may not upgrade correctly. Once again, it is strongly recommended that you back up your database before you begin the upgrade.

The SQL scripts to update your database are located in upgrade directory where you extracted the 6.1 database scripts. Use the script that is appropriate for your database platform. For example, if you have a MySQL database, do the following:

1. On the command line, change to the directory where you extracted the Elastic Path 6.1 database scripts.
2. Change to the upgrade/mysql subdirectory.
3. Start the MySQL database client.

   mysql -u<user> -p<password>
   

4. Execute the upgrade script:

   source 6-0-3To6-1.sql
   

When the script completes execution, create another backup of the database. You will need to make further database changes when you migrate your settings to the new settings framework, and it is a good idea to back up the database again before making those changes.

New settings added in 6.1 are assigned default values after upgrade. You will need to review them to ensure that the meet your requirements.