Cause
After reinstall mariadb, replace all DB files in folder “data” directly could cause this error and service “MariaDB” will never started.
Solution
- Check error log:
https://mariadb.com/kb/en/library/what-to-do-if-mariadb-doesnt-start/
C:\Program Files\MariaDB 10.4\data\REX-PC.err - Create an option file and put it in %WINDIR%/my.ini
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
12[mysqld]innodb_force_recovery = 6 - Run command to start mariadb: (under folder bin)
1mysqld --verbose - You should be able to connect to DB server now
- Export tables in standard way.
- Uninstall DB server
- Install DB server