MySQL database restore fails
This is a wiki article created by HostingRails users. Please login or signup to make edits.
Hi everybody,
I have a database on my local machine which I uploaded to my domain.
Now when I try to restore my database as follows I get an error message.
#mysql --user= login_someuser --pass=mypass login_appname < login_appname.sql
Access denied for user 'login_someuser'@'localhost' to database 'login_appname'
Any idea why ? I have double checked my username and password. I have created the database with same username password from the cPanel and into which I wish to import this data.
Is there a specific procedure to follow?
Thanks,
railsfan
UPDATE:
This problem was my own mistake as I had not properly associated the user for the database from cpanel. Database is working now. However, I get the the "Rails application failed to start properly" error when I access the web page. Checked permissions etc. Still no luck.
Railsfan