Page log sequence number error of MariaDB


After reinstall mariadb, replace all DB files in folder “data” directly could cause this error and service “MariaDB” will never started.


  1. Check error log:
    C:\Program Files\MariaDB 10.4\data\REX-PC.err
  2. Create an option file and put it in %WINDIR%/my.ini

    innodb_force_recovery = 6
    1. Why 6?
  3. Run command to start mariadb: (under folder bin)
    mysqld --verbose
  4. You should be able to connect to DB server now
  5. Export tables in standard way.
  6. Uninstall DB server
  7. Install DB server