How to Recover MariaDB
Applicable Ephesoft Transact Versions: 4.0.2.0 or above
This article provides instructions on how to recover MariaDB.
- Open the my.ini file in the dependencies\mariadb folder
Figure 1. My.ini file
- 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
- Save the my.ini file
- Start the MariaDB service.
- 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.
- Once you confirm the ability to connect to the database, open the my.ini file and remove the added line in step 2.
- Start the Ephesoft Transact service.