Hi,

I do commit alright. This doesn't happen often. i insert into the tables 
from a java web app. The db and the data in it is fine when i stop and 
restart the web server(tomcat). sometimes when i restart the machine, 
data is all intact. 

I was using the mysql 4 max before. Same thing happened with that too. i 
guessed that was because of the alpha version db. so i downgraded to 
mysql3.23. 

regards,


On Thu, 2 May 2002, Jeremy Zawodny wrote:

> On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote:
> > 
> > I have created only one database with 18 tables. Only one of these tables
> >  is MyIsam table. rest are BDB tables. When the server is up, it works 
> > fine. but when i reboot the machine, few of the tables loose all the 
> > records they held before the machine was rebooted. This doesn't happen 
> > everytime. It happens randomly. 
> > 
> > One more thing i noticed is that when i run the 'show table status' it 
> > says 10000000 rows in the table that has lost all the records.
> 
> This will sound dumb, but are you sure you're committing your
> transactions?
> 
> Jeremy
> 

-- 
_________________________________________________________________
TP R Murthy (Systems Analyst)
Cerulean Information Technology Pvt. Ltd.
#24, floor#2, 5th Main, 5th Block, Koramangala, Bangalore-560 095.
Phone: 299-1886, 299-1897
web:http://www.ceruleaninfotech.com
_________________________________________________________________
Life is a Dream. Dont Wake up.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to