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