Recover MariaDB database backups with AhsayOBM

26 Aug, 2024

Ahsay simplifies MariaDB database recovery with its automated processes. AhsayOBM swiftly restores MariaDB database files from the backup destination and applies them to the MariaDB database instance, either on the original server or remotely to a standby server over the LAN. For system administrators who prefer greater control over the recovery process, the “Restore Raw File” option is available. This feature allows AhsayOBM to restore the database files to a local disk, after which the system administrator must manually create the databases and import them into the MariaDB instance either on the original database server, or copy the files to a standby or remote server.

Please use the following steps and tips to make MariaDB database recovery quick and reliable using AhsayOBM.

How to:

  1. Before running the restore job, open and login to the MariaDB Command Line Client.
  2. Verify that the database instance is running by using the command show databases.
  3. After verifying, open and login to AhsayOBM.
  4. From the AhsayOBM home screen, click [Restore].
  5. Select the backup set containing the database/s you want to restore.
  6. Check the Temporary Directory.
    • Ensure the following:
      • Directory is a valid location when restoring on a replacement machine.
      • Directory is not set to the same drive where Windows OS is installed.
      • Directory is not set to a network drive as it may affect the restore performance.
  7. Select where to restore your data from.
    • It is recommended to select a local destination, if applicable.
  8. Select what to restore: Choose from files as of job
    • Default selection shows the latest version. You may select a specific version by clicking the menus next to it.
  9. Select the databases you aim to recover.
  10. Click [Next].
  11. Enter the host, port, username, and password.
  12. Modify the "Verify checksum" setting" if preferred.
  13. Click [Restore].

Recover deleted and existing databases to the original machine

  1. Before running the restore job, open and login to the MariaDB Command Line Client.
  2. Verify that the database instance is running by using the command show databases.
  3. After verifying, from the Restore page of AhsayOBM, select what to restore. You may select a previous version or keep the default selection which is the latest version.
  4. Select databases to recover.
  5. Click [Next].
  6. When restoring to the original machine, the host, port, username, and password do not have to be modified. Click [Next].
  7. A warning sign on a new database's name indicates that an existing database has a similar name and may be overwritten after the restore job. Change the name of the database if you want to clone an existing database to compare information.
  8. Click [Restore].
  9. Verify if the databases have been recovered through the MariaDB Command Line Client. Use the command show databases.

Recover files to an alternate/standby machine within the same LAN

  1. Before running the restore job, open and login to the MariaDB Command Line Client using the alternate/standby machine.
  2. Verify that the database instance is running by using the command show databases.
  3. After verifying, from the Restore page of AhsayOBM, select what to restore. You may select a previous version or keep the default selection which is the latest version.
  4. Select databases to recover.
  5. Click [Next].
  6. For host, enter the IP address of the alternate/standby machine. Then modify the port, username, and password, if required.
  7. Click [Next].
  8. Default system databases may be selected. Specify a new name for the databases, if preferred. Otherwise, a warning message will appear to ask for confirmation to overwrite the existing databases.
  9. Click [Restore].
  10. To verify if the databases have been recovered, open and login to the MariaDB Command Line Client on the alternate/standby machine. Use the command show databases.

Recover databases manually

Note: Manual recovery requires advanced knowledge of MariaDB database, including commands and procedures.

  1. Before running the restore job, open and login to the MariaDB Command Line Client.
  2. Verify that the database instance is running by using the command show databases.
  3. After verifying, from the Restore page of AhsayOBM, select what to restore. You may select a previous version or keep the default selection which is the latest version.
  4. Select databases to recover.
  5. Enable Restore raw file.
  6. Click [Next].
  7. Click [Browse] and select a local destination. Click [OK].
  8. Click [Restore].
  9. To verify if the databases have been recovered:
    1. Check the Restore Report to confirm if the selected databases have been restored to the selected destination.
    2. Open the selected destination to check if the selected databases have been recovered.
  10. Open the MariaDB Command Line Client. Use the command show databases.
  11. To manually create and import the databases into the MariaDB server:
    1. Use the command create database [name of the database];
    2. Then use [name of the databases];
    3. Followed by source [letterdrive:\folder\subfolder\filename]
    4. Example: source d:\abc\123\world.sql
    5. Check the queries and make sure no error exists.
    6. To see the informaton of the database:
      1. Use the command show tables.
      2. You may check the information of a table by using select * from [name of the table].
      3. You may count the rows of a table by using select count(*) from [name of the table].
Video Page
Recover MariaDB database backups with AhsayOBM