Re: 127 Error Handler

[Harrison Fisk]

Hi,

The issue is that you are using non-transactional tables. The above is how MyISAM tables work, they assume that they will operate uninterrupted. You can use an option like --myisam-recover if you choose, which will cause MySQL to automatically try to repair the table if it is corrupted.

The other option is to switch your tables to InnoDB. InnoDB is a transactional table type, meaning you can do all of the BEGIN/COMMIT/SAVEPOINT operations that you are used to with Oracle. You can read more about InnoDB at http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html or just the concept of different storage engines at http://dev.mysql.com/doc/mysql/en/Storage_engines.html

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com