How to Recover MariaDB

Applicable Ephesoft Transact Versions: 4.0.2.0 or above

This article provides instructions on how to recover MariaDB.

  1. Open the my.ini file in the dependencies\mariadb folder

Figure 1. My.ini file

  1. Add the following line below the port value:
innodb_force_recovery=1

Note: This change should be made under the [mysqld] section of the my.ini file.

Figure 2. Adding innodb_force_recovery=1

  1. Save the my.ini file
  2. Start the MariaDB service.
  3. Once the MariaDB service has started, check the database with a database client, which is included in Ephesoft Transact as HeidiSQL, and ensure that you are able to login.
  4. Once you confirm the ability to connect to the database, open the my.ini file and remove the added line in step 2.
  5. Start the Ephesoft Transact service.