Can’t start mysqld/mysql or MariaDb on Windows

[ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions. 

Open cmd and type:

mysqld --tc-heuristic-recover=ROLLBACK

or

mysqld_safe --tc-heuristic-recover=COMMIT

Leave a Reply

Your email address will not be published. Required fields are marked *