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...