Back up, Restore, and create or upgrade a database

Opkey provides the capability to create, backup, and restore databases while working with the MySQL workbench. You can perform these operations with the help of Opkey Database Manager. 

1. Open the Opkey Database Manager on your local device by clicking on its icon on your home screen. The UI contains three radio buttons with the following capabilities.

• Backup Database

• Create or Upgrade Database

• Restore Database

  
  

  

2. Now, to back up a database, click on the Backup Database radio button and then proceed to click on the Next button.

3. Please read the instructions carefully and click the Next button.

4. In the following window, fill in the details related to the database. Fill in the Hostname and Port, select a Schema, and choose a Backup Location. Check the box Include Execution Result Data in DataBase Backup to backup existing test execution data.

It will check the version of the data to be taken as a backup and store it in the specified location. Finally, click on the Backup button to complete the process.

Now, let's look at the process of restoring databases.

1. Select the Restore Database option on the Opkey Database Manager and click the Next button at the bottom.

2. Please read the instructions carefully and click the Next button.

3. Fill in details such as:

• Host

• Port

• Username

• Password

• Opkey Backup Path

• Shared Disk Path

You can check the box to take a backup of the data and then proceed to click on the Restore button to complete the database restoration process. It will then first take the backup and then restore the data.

Let's understand the process of creating and upgrading the database. 

1. Click on the Create or Upgrade Database button.

2. You’ll get the option of either Creating new database or Upgrade existing database. To create a new database, select the Create new database option.

3. Next, fill in the details of :

• Host: Provide the IP address of the machine where the database will have to be created

• Port: Add port number

• Schema: Schema Name

• Username

• Password

After this, click on the Create button. It will connect with the Workbench and will begin creating the database.
 


4. A new version of the database is created. This version is synced with the data present in the main database.

Note: If you want to keep the particular database in the shared location, you have to provide details of the shared location path, either of AWS or the shared system path. After this, click the Apply button at the bottom to finish the process.

5. If you want to upgrade an existing database, select the Upgrade existing database option.

6. Fill in the new details to update the database and click the Update button at the bottom.

To learn more about configuring databases, you can visit https://university.opkeylms.com and enroll in our Opkey series course.