MySQL Forums
Forum List  »  MyISAM

MyISAM Rollback Equivalent
Posted by: tlurz
Date: March 16, 2006 10:24AM

The MySQL install I am working with only has MyISAM. I am used to working with InnoDB for the rollback capabilities and so I have relatively no experience with MyISAM.

The application I am developing will need to do some update/write statements. I realize the MyISAM is not ideal for such use but I do not have InnoDB capabilities.

With MyISAM, what is the normal convention to use when an error occurs? Is there any way to do something like a rollback to protect the tables? I'm all for error handling, but what do people normally do with the database using MyISAM when an error occurs? I figure that on a write error I can delete the row created if it was created. What would be a good way to repair an error on an update?

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM Rollback Equivalent
9600
March 16, 2006 10:24AM
4957
March 17, 2006 10:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.