My site is hosted on godaddy server. When I attempted to restore my database to an earlier date, I got a 503 Service Unavailable error shown below.:
ERROR: Unable to connect to database 'my_database_mage1' using 'magento'!
ERROR: Database restore failed!
I got the following error in an email from cron:
@eakenbor can you please let me know whether your website is not connected with database or restoring of database is not working?
@rahulGupta thanks for your response. The problem is both. The database restore failed due to a 503 Service Unavailable error and now the site cannot connect to the database due to the same error.
@eakenbor by using the credentials from your local.xml, are you able to access your database ?
Thanks @rahul Gupta. There is no interface to login into mysql because I get unfettered access to phpMyAdmin direct from my cpanel. I tried to access the database by clicking on "Manage" next to my hosting account in my godaddy account, but that failed due to the lack of connection between the site and the database. Or is there any interface you know I can use to connect? However, I am sure the password and username are correct because I had to reset it very carefully.
Has GoDaddy support been able to help you?
Ideally, if you're on Magento, you should have a web host that can help you diagnose and resolve an issue like this quickly and effectively.
@Robert Rand Godaddy has so far been clueless and in denial about the problem. Initially they claimed it was a Magento problem despite the error being a 503 status which makes it a server error. Now they have said they are looking at it and it has been a week.