search for: mynewdatabasename

Displaying 1 result from an estimated 1 matches for "mynewdatabasename".

2010 Aug 16
0
Restoring blob fileds in Mysql
...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...