When building a database of my DVD collection which includes BLOB images of png images of the covers, the database can be backed up, but it cannot be restored. This of course makes the backups useless. The images are 475×475 pixel PNG images.
UPDATE: Problem solved. Parameter max_allowed_packet is the packet size for requests. This defaults to 1M and needs to be larger to allow this restore to work. Setting the max_allowed_packet parameter to 10M allowed the restore to complete successfully.
I just got a new Alienware m15x. Great machine. Very nice design. But I’m running into a couple of problems.
Update: 8 June 2008 9pm– I spoke too soon. The problem is back in spades. See section later in this post regarding use of SysInternals Process Explorer with more data on the problem.
Update: 8 June 2008 – The CPU Busy problem is not occurring for about the past 2 hours. The system was idle – but with the CPU busy for several hours today. There appears to be no reason for this change. It bears watching.
Update: 7 June 2008 – New information added on CPU Busy.