I am prepping to move my existing Omeka collection to a new server. I have successfully installed version 1.5.1 on the new server, so no problems there. When I go to upload my old database onto the new server, I receive the following error:
-- Current Database:
CREATE DATABASE /*!32312 IF NOT EXISTS*/
jmroman /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
#1044 - Access denied for user 'romanarchivecom'@'184.108.40.206/255.255.128.0' to database 'jmroman'
I tried manually modifying the permissions on the .SQL file, but I still get this error. How can I get the database to upload successfully?