Your DrCloudEHR database uses MySQL Server 5.6.47 as the database service. You can use the MySQL Workbench to perform administration operations on your DrCloudEHR database, including backing up and restoring the database.

Download the MySQL Workbench

Click here to download the MySQL Workbench. MySQL Workbench 8.0 is the current release, and works with all MySQL Server 5.6.x versions.

Connect to the DrCloudEHR Database

1. Open MySQL Workbench and then select Manage Connections from the Database menu.
2. Click the New button at the bottom of the window.

3. Enter the connection properties:

   Property	Description
   Connection Name	Enter a meaningful name.
   Connection Method	Leave this set to Standard (TCP/IP).
   Hostname	Enter the IP address for the database server.
   Username	Enter the database user name.
   Password	Select Store in Vault and enter the database user password in the prompt that appears.

   
   

4. Click Test Connection to verify the connection.

Back Up the Database

1. Log in to MySQL Workbench.
2. Click the Server tab, and then click Data Export .
3. Click the Object Selection tab, and then select the checkbox for your database. Enter your database user password if prompted.

4. Choose where you would like to save your database backup. 

   • Export to Dump Project Folder: Select this option to create a separate backup file for each table in your database, which will make it possible to store selected tables in the future without the need to restore the entire database.
   • Export to Self-Contained File: Select this option to export all selected tables to a single SQL file. This is the simplest option to use when restoring the database.
5. Click Start Export. Enter your database password if prompted.

Restore the Database

1. Select the database to import the backed up data to in the MySQL Connections window.
2. Click the Server tab, and then select Data Import.
3. Import the data. The process you follow will depend on the backup option you selected.
   • If you selected the Select Import from Dump Project Folder option:
     • Enter the location of the backup dump file in the Folder Path text field.
     • Click Load Folder Contents.
     • Select the tables from the backup you would like to restore.
   • If you selected the Export to Self-Contained File option:
     • Select Import from Self-Contained File.
     • Enter the location of the backup file in the File Path text field.
4. Click Start Import. Enter your database password if prompted.