# Restoring blob fileds in Mysql

**URL:** <https://www.ruby-forum.com/t/restoring-blob-fileds-in-mysql/193327>\
**Category:** Rails\
**Created:** [August 16, 2010, 6:01am UTC](https://www.ruby-forum.com/t/restoring-blob-fileds-in-mysql/193327 "2010-08-16T06:01:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![giorgio](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/cab0a1/32.png) [@giorgio](https://www.ruby-forum.com/u/giorgio)\
**Post date:** [August 16, 2010, 6:01am UTC](https://www.ruby-forum.com/t/restoring-blob-fileds-in-mysql/193327/1 "2010-08-16T06:01:23Z")

</div>

Not really a rails question but someone on here may be able to help…

I have been backing up a MySQL database for a Rails app for several  
years with the command: mysqldump myDatabaseName -u root \>  
myBackupFile.sql

The backups have appeared to work fine…

I then wanted to restore one of the backups to a different named  
database so I did: mysql myNewDatabaseName -u root \< myBackupFile.sql

I got some errors about logfile size so I stopped Mysql and removed  
the logfiles and set the following parameters in the my.ini file and  
restarted mysql.

innodb\_log\_file\_size=64M  
innodb\_log\_buffer\_size=8M

The restore now completes with no errors but one of the three tables  
which contains blobs is never restored.  
My max-allowed-packet is set to 32M

The database backup size is about 2.2 GB the majority of that size  
being in the table that does not restore. If I run a mysqldump on the  
restored database the size is 185 MB.

I really need to have a bombproof way to backup and restore as my  
existing backups appear worthless. I am particularly concerned that it  
“fails silently” with no error log entries as far as I can see.

Is yaml\_db reliable for blobs?  
The environment is windows server 2003 sp2

Any help appreciated!

George