Database Upgrade

Follow the steps to migrate from the current version to the latest version of Cross Identity:

1. Login to MySQL as an administrator user.

   mysql -u root -p

   
2. Create a new folder with the current date in the database server and copy the new database schema.
3. Create a new backup folder in the new database schema with the current date.
4. Create a database once logged in.

5. create database <databasename>;

6. Take the dump of existing mysql schema.
7. mysqldump -u root -p databasename> path/filename.sql;
8. Import the dump to the new database.
9. mysql -u root -p newdatabasename <” /path/dump.sql”.
10. Import the migration script to the same database.
11. mysql -u root -p newdatabasename <”/path/migrationscript.sql”.
    Note:

    Configuration information should be updated according to the Client environment (such as IP, Ports, etc.).
12. If adding any new tables or adding new columns in the updated database, then run the specific query provided by the Product team.
    Note:

    Please replace the ‘?’ with the corresponding tenant ID of the customer tenant.