Recover MySQL database backups with AhsayOBM

27 Aug, 2024

Ahsay makes MySQL database recovery easy. Automated recovery quickly restores MySQL databases files from the backup destination and applies them to the MySQL database instance either on the original database server or remotely to a standby server over the LAN. For system administrator's who prefer more control over the recovery process, they can use the "Restore raw file" option, where AhsayOBM will restore the database files to local disk, the system administrator will have to manually create the databases and import them into the MySQL instance.

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

How to:

  1. Before running the restore job, open and login to the MySQL 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 MySQL 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 MySQL 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 MySQL 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 MySQL Command Line Client on the alternate/standby machine. Use the command show databases.

Recover databases manually

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

  1. Before running the restore job, open and login to the MySQL 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 MySQL Command Line Client. Use the command show databases.
  11. To manually create and import the databases into the MySQL 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 MySQL database backups with AhsayOBM