Updates not committing, rollback seems to be happening.

Hi,

Bit of background. I have two OS X Servers running 10.5.2, one has the default MySQL installation, I believe it's 5.0.42 and the other has 5.1.? (I just downloaded it from MySQL, the latest one).

I have a database with a table, it's called DMS. This table was using the InnoDB engine. I have recently moved this database from a Windows XP MySQL setup and basically just dumped the SQL file from XP and imported it to the OS X copy. All worked without a glitch. This was a week ago.

I have now tried to amend data in the DMS table, I have ben doing it all week without issues but not as much as yesterday/today.

I would change information in one column field, digits, single but when I refreshed the screen the original entries were there. I did it again and again, same thing, it's as if it's on "auto rollback" or something. I then thought maybe it's the user account I was using. I was remotely connecting from my Mac laptop. I made sure the root account has every permission including LOCK. Still didn't work.

It just seemed to be a locking issue with the table so I disconnected all other sessions connecting to the server. It seemed to work - sort of intermittent, I would change some data and it would be fine, I'd change it again and it would revert back to it's original state, the one even before the last one I did.

I decided to change the database engine from InnoDB to MyISAM in the hope that if locking was the problem this would clear it up. It's accepting more changes now than with InnoDB but still getting several 'cannot commit post' errors. I thought it may be the version of MySQL so I tried it on the 5.1 installation on my other server, still the same.

Any ideas what could be the problem?

Any help would be much appreciated.

Regards

Ken