MySQL data base document management server not working properly after update

Asked By rodriguezscotte 20 points N/A Posted 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 ? 

• Status: Open
• Question Views: 785
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Sharath Reddy 590495 points N/A #143738

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 08/18/2013
• Question Category: MySQL Server