Have you ever encounter failing to start your MySQL server that throws this kind of error:
1 |
[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. |
This occurs when your server suddenly shutsdown or runs out of power while mysql is internally processing data. To resolve this error, you will have to rollback or commit the corrupt mysql transaction by running the following commands:
For unix systems:
1 |
service mysql start --tc-heuristic-recover=ROLLBACK |
For windows:
1 |
mysqld --tc-heuristic-recover=ROLLBACK |
After running the respective commands above, you should be able to successfully start again your MySQL server.
Be First to Comment