This is Vishal Gupta (Microsoft MVP). I run AskVG.com and need some help from you all.
Yesterday I faced a strange problem. Whenever I tried to open the site, it opened a blank page. When I tried to access Admin panel, I got following message:
Database Upgrade Required
Your WordPress database is out-of-date, and must be upgraded before you can continue.
The upgrade process may take a while, so please be patient.
There was a button "Upgrade WordPress", I clicked on it and it showed a long list of SQL commands but each line contained following error:
WordPress database error MySQL server has gone away
There was a button at below "Continue", when I clicked on it, it again showed the same "database Upgrade Required" page. So it became an endless loop.
We decided to restore a recent database backup and it worked and the site started working again.
So now my questions are as follows:
1. Why this problem occurred suddenly? We didnt change any setting, we didnt install or update any plug-in, we didnt add any script. We didnt do anything new except creating new post.
2. How can we assure that this problem will not occur again?
So guys, please help and tell me what was the reason behind this strange problem?
PS: Also since a few days I'm getting various core dump files in "public_html" folder. Size of each file is 50MB. When I asked our host he told that its not a server side problem. It must be a plugin which is causing these core dump files.