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)?

Can you load the database via command line instead of through phpMyAdmin?

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.

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.

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?

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.