MySQL Forums
Forum List  »  MyISAM

Database Rollback?
Posted by: Christine McLennan
Date: April 04, 2006 04:45PM

I am running MySQL v4.1.14 on a Windows 2000 Server.

My tables are all MyISAM and for some reason, the database did a rollback when the server was rebooted, wiping out a days worth of invoicing. (The db is built to store records for an invoicing application.)


Also - other issues keep popping up - an invoice will be created (assigning an invoice Id, say 711) Now the 'parent' invoice table does not allow duplicate invoice id's - however strangely enough invoice 711 was created and printed off - then the clerk created another invoice - in which the same # was issued (711) and all record of the previous 711 was gone. Almost like it was saved - then a small rollback occurred. (As other child tables hold the line item info - etc - and no record of those was found either.)

There is a condition in the application in which the invoice must be saved before it is printed off - as the print routines pull the data from the database.

Any idea why this would happen? I thought MyISAM did not allow rollbacks to happen? - there are none in the code anyhow.

Your help is appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Database Rollback?
8210
April 04, 2006 04:45PM
2724
April 05, 2006 12:14PM
2359
April 05, 2006 03:55PM
2249
April 05, 2006 12:22PM
2300
April 05, 2006 04:02PM
2047
April 06, 2006 01:53AM


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.