Brian M. Veteran Posted January 28, 2008 Veteran Share Posted January 28, 2008 Hi, I'm trying to restore a backup of a database on my home server, and whenever I attempt, the SQL server just dies - no error or anything, the process just quits. I've checked the logs, and there's nothing in there that would help. The database backup I'm trying to restore is a 6.2MB database dump. Server's CPU/memory load do not spike before the crash, and everything appears to be normal apart from the SQL server dying on me. The server itself if a fairly beefy machine (q6600 running at 3.2ish, 8GB ram, drives in raid1), so in all honesty, should be able to cope. Anyone know what might be causing this (running on CentOS by the way)? Link to comment Share on other sites More sharing options...
Mathachew Veteran Posted January 28, 2008 Veteran Share Posted January 28, 2008 Can you load the database via command line instead of through phpMyAdmin? Link to comment Share on other sites More sharing options...
zivan56 Posted January 28, 2008 Share Posted January 28, 2008 What do you get from /var/log/mysql/error.log (or something to that extent)? Maybe other logs may hint as to what is happening (i.e access_log). PHP is not that efficient for loading a backup, you should probably use the command line as mentioned. Link to comment Share on other sites More sharing options...
Brian M. Veteran Posted January 28, 2008 Author Veteran Share Posted January 28, 2008 Yeah, I can use the command line just fine, I was just wondering what would cause this (more to the point, I was curious if it was a bug in my software/config etc). Ivanz, none of the logs show anything that relates to the error. One of the log files notes the usual access stuff, but there's nothing in there that shows any sort of error/delay etc - I spent about 15 minutes scanning through them. Link to comment Share on other sites More sharing options...
jameso Posted February 5, 2008 Share Posted February 5, 2008 What version of PHPMyAdmin are you using? Is it the latest stable version? 2.11.4 seems to be the latest version. I would suggest upgrading to 2.11.4 and seeing if the error still occurs. When MySQL crashes, what do you have to do to get it running again? Restart MySQL? Restart the entire server? Link to comment Share on other sites More sharing options...
Brian M. Veteran Posted February 5, 2008 Author Veteran Share Posted February 5, 2008 I'm currently running 2.11.0, and I had to restart MySQL. The problem seems to have rectified itself however - appears SQL was just having an off day. Link to comment Share on other sites More sharing options...
Recommended Posts