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.
Continue reading “MySQL Unable to Restore”