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