MySQL Forums
Forum List  »  Backup

Backup Restore just stuck
Posted by: Remy Blaettler
Date: July 21, 2010 01:56AM

I have normal with mysqldumb created backup file. It's about 15GB and contains a lot of blobs. Max size per blob is 30MB.

Now when I try to restore the backup, the process just gets stuck.
mysql -uuser -ppassword dev_supertext < supertext.sql

It get stuck while writing back the biggest table with the blobs. There is no error message and mysql is still running fine.

This is on a 64bit 5.1.48 community edition for Windows server.

max_allowed_packet is set to 40MB and is not the problem. I had that before.

Any other settings I could check or something I can monitor during the restore?
Didn't see anything special in the query or error log.

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup Restore just stuck
5224
July 21, 2010 01:56AM
1484
July 28, 2010 09:15PM
1526
September 30, 2010 06:03PM
1317
September 30, 2010 09:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.