mysql restore

mysql database restores that include large binary blobs might fail.

first variable to modify would be: max_allowed_packet
increase the value as needed for the restore.

other variables of interest:
net_write_timeout
net_read_timeout

took 27 minutes to restore an approx 2.5gb database.

This entry was written by resinblade , posted on Wednesday January 13 2010at 11:01 pm , filed under IT . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Leave a Reply

You must be logged in to post a comment.