Embold backup & restore database

This guide will help you to backup your Embold data and restoring it. With this process, you can backup your source code, scans with all its pre-requisites. 

• The BrowserStack Code Quality version on the source and destination machines should be the same.
• Stop BrowserStack Code Quality service on the destination machine.
• You must have administrative privileges.
• The script works with default database names as corona and gamma.
• Share/mount the directory which shall be accessible to source machine if the backup/restore is been done on the remote machine.
• Create a backup directory beforehand and provide write permissions where the backup is to be saved.
• You must be aware of the BrowserStack Code Quality installation directory path for backup/restore on the same platforms.
• In the case of Linux platform, to restore BrowserStack Code Quality, remove the password authentication from the remote destination.

This will include the information of database backup and restoration of Windows operating system.

A. Database backup on windows

The databases from the source BrowserStack Code Quality machine is backed up using the following steps:

1. Get the batch file at C:\ProgramData\Gamma\gamma_ui\dbscripts\scripts\backup_restore.bat.
2. Execute the file. A command prompt will be displayed. Follow the inquiries to backup the database.

B. Files backup on windows

The source files from the source BrowserStack Code Quality machine are backed up using the following steps:

1. Get the batch file at C:\ProgramData\Gamma\gamma_ui\dbscripts\scripts\backup_restore.bat.
2. Execute the file. The command prompt will be displayed. Follow the inquiries to back up the source and logs.
   

   

3. To back up the logs, provide the destination directory as shown in the below screens.

   

A. Database restoration on windows

The databases from the source machine is restored using the following steps:

1. Get the batch file at C:\ProgramData\Gamma\gamma_ui\dbscripts\scripts\backup_restore.bat.
2. Execute the file. The command prompt will be displayed. Follow the inquiries to restore the database.
3. Provide the same sql paths which we have generated in destination folder during Backup-Process

B. Files restoration on windows

The source files from the source machine are restored using the following steps:

1. Get the batch file at C:\ProgramData\Gamma\gamma_ui\dbscripts\scripts\backup_restore.bat.
2. Execute the file. The command prompt will be displayed. Follow the inquiries to back up the source and logs.
3. Provide the same destination data folder path which we have generated during Backup-Process
   

   

4. To restore the logs provide the destination directory as shown in the below screen.
5. Provide the same destination logs folder path which we have generated during Backup-Process
   

   

This section gives information of database backup and restoration of Ubuntu/RHEL/CentOS

A. Database backup on Linux/RHEL/CentOS

The databases from the source Embold machine is backed up using the following steps:

1. Get the shell file at /gamma_ui/dbscripts/scripts/backup_restore.sh.
2. Execute the shell script with Postgres password.

For Example:
./backup_restore.sh
The command prompt will be displayed. Follow the inquiries to backup the database.

B. Files backup on Linux/RHEL/CentOS

The source files from the source Embold machine are backed up using the following steps:

1. Get the shell file at /gamma_ui/dbscripts/scripts/backup_restore.sh.
2. Execute the file. The command prompt will be displayed. Follow the inquiries to back up the source and logs.
   Note:
   The inputs to be provided are case sensitive.
   
   
3. To back up the logs, provide the destination directory as shown in the below screens.
   

This section provides information for database restoration and file restoration.

A. Database restoration on Ubuntu/RHEL/CentOS

The databases from the source Embold machine is restored using the following steps:

1. Get the shell file at /gamma_ui/dbscripts/scripts/backup_restore.sh
2. Execute the file. The command prompt will be displayed. Follow the inquiries to restore the database.

B. Files restoration on Ubuntu/RHEL/CentOS

The source files from the source machine are restored using the following steps:

1. Get the shell file at /gamma_ui/dbscripts/scripts/backup_restore.sh
2. Execute the file. The command prompt will be displayed. Follow the inquiries to back up the source and logs.

For gamma_data and gamma/logs folders change the owner to Embold at the destination machine. Give 755 permission to gamma_data folder and gamma/logs folder.

To restore the logs provide the destination directory as shown in the below screens.