I recently had to move from one hosting provider to another (if you're in the UK don't use Easyspace for your VPS!) as my previous host dumped my server without warning.
Fortunately I had remote backups in place and I've been able to restore almost all of my client sites and databases without a hitch. Except this one.
Since I restored my databases, some of them are exhibiting very unusual behaviour, specifically NULLing out rows of data or certain fields across multiple rows.
Has anyone experienced this before/know what the cause is? It only seems to occur when records are updated.
My backups consisted of a
mysqldump --all-databases
I restored to my new MySQL server using phpMyAdmin initially. Then I tried again, importing directly into MySQL from the command line and the same thing is happening.