All recent changes in MySQL have been automatically removed. Recently INSERTed or UPDATEd data is not available I have been using MySQL for the last two months. I'm regularly INSERTing new records and UPDATEing old ones. But when I opened phpMyAdmin today, all of the changes which I've made in the 10 days have vanished.
INSERTed data for the last 10 days is unavailable and The UPDATEs I have made to other records have also reverted to previous versions.
The AUTO_INCREMENT field is still incrementing to the next number like nothing is DELETEd.
I need my recently INSERTed data and my UPDATEs restored.
More importantly perhaps, why is this happening?
This problem happen between 5th to 7th January. This is the Error file of these days:
Error Log
set autocommit=OFF
Do lots of INSERTs/UPDATEs/DELETEs
disconnect

Step 3 will do an implicit ROLLBACK since there was no COMMIT.  And this is why I advise against ever using autocommit=OFF.
And, yes, the AUTO_INCREMENT would not be reset.  That's just one of the quirks of auto_inc.  (Actually, it is an efficiency measure.)
So... either
SET autocommit=ON;

and leave it that way.  Check the configuration, too.  Or use transactions:
BEGIN;
inserts, etc
COMMIT;