N/APosted on - 09/12/2012
A recent update on MySQL database document management server has started giving me "incorrect key file for the table" error.
Is there anyway I can go back to the previous version ?
MySQL data base document management server not working properly after update
By default, MySQL runs with autocommit mode enabled. This means that as soon as you execute a statement that updates (modifies) a table, MySQL stores the update on disk to make it permanent. Beginning with MySQL 5.0.3, the optional WORK keyword is supported for COMMIT and ROLLBACK, as are the CHAIN and RELEASE clauses. CHAIN and RELEASE can be used for additional control over transaction completion. The value of the completion_type system variable determines the default completion behavior.
The AND CHAIN clause causes a new transaction to begin as soon as the current one ends, and the new transaction has the same isolation level as the just-terminated transaction. The RELEASE clause causes the server to disconnect the current client session after terminating the current transaction. For further reading about this matter, you may refer to 13.3.1. START TRANSACTION, COMMIT, ROLLBACK Syntax.