Jump to content

Lost data


djp1988

Recommended Posts

Hi, I altered an info in a database entry and my comments VARCHAR(500) field lost data, I realized after I had done the sql to modify something else in the field, is there a way to retreive this bearing in mine that I am still logged in and that operation is less then 10 operations old? is there a 'history' button ???I am on mysqladmin

Link to comment
Share on other sites

You might be able to roll back the transaction, but I think you need to enable transaction logging first. If it wasn't enabled when you did the transaction then you won't be able to roll it back. I'm not even sure if MySQL supports that, I've just seen that type of thing with SQL Server. I doubt you can recover the data, unless you have it backed up somewhere.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...