SQLyog loses data from longtext fields (possible other memo type fields too). I've had this happen to me a few times when updating data and it is frustrating because it wasn't always reproducible. However, I think I have managed to find a way of always reproducing it though there may be other ways too.
1. Ensure your table has a longtext field and a few rows of data already entered inside
2. Go to an existing row, click on the button to bring up the Insert/Update Blob Field form and put in some data then click OK
3. Click on a cell in another row (any cell in any other row other than the one you are on)
4. Now we need to go back to the row where we inserted data except this time, click on a different cell in the same row. Then edit it. E.g. if the cell had the number 1 inside, change it to 2. After editing, straight away click on Done (do not move to another row first).
The data you entered in the blob field will be lost – or at least it is happening for me!
Can anyone confirm that it is also happening for them?
