waigy Posted December 18, 2015 Share Posted December 18, 2015 I had "error establishing database" for a few days.I managed to get it working again using help that I found in this forum by deleting my database username and creating a new user. But during my time trying to sort the problem I went into phpmyadmin and imported an sql file which seemed to sort some errors, but it's an old sql file so the blog is now outdated. I have newer backups as xml files and also have backups of my whole site by ftp which includes the whole blog folder. What's the best way to get the latest blog back? Link to comment Share on other sites More sharing options...
wolstech Posted December 18, 2015 Share Posted December 18, 2015 With the backups you have, I'm not sure you can. Ive never heard of XML database backups. The blog folder files don't hold any data, so restoring them won't help. Did the issue happen when the server was fixed a while back? If so, krydos can restore the version you had immediately prior to the repair. If this is the case, please post your account name and the name of the broken database. Link to comment Share on other sites More sharing options...
waigy Posted December 18, 2015 Author Share Posted December 18, 2015 The blog hasn't been updated since a few months ago so the krydos restore version should be fine.I think my account name is waigy and the database name is waigy_blog Link to comment Share on other sites More sharing options...
wolstech Posted December 18, 2015 Share Posted December 18, 2015 This support request is being escalated to our root admin. 1 Link to comment Share on other sites More sharing options...
Krydos Posted December 18, 2015 Share Posted December 18, 2015 The database waigy_blog should now be visible to your root mysql account. You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected database. If phpmyadmin doesn't log in properly or you don't see the database there change your account password and this should sync up the mysql/cpanel passwords. Let us know if you're still having any issues accessing your data. 1 Link to comment Share on other sites More sharing options...
waigy Posted December 18, 2015 Author Share Posted December 18, 2015 All working fine again, thanks. Link to comment Share on other sites More sharing options...
Krydos Posted December 18, 2015 Share Posted December 18, 2015 Thanks! As a free service we don't have an advertising budget because we would rather invest all of the money that we do have into providing better service and improving the servers so we really appreciate the word of mouth recommendations that our satisfied users provide. Feel free to post about us on social media like twitter, facebook, hosting review sites, your personal websites or blogs, and anything else you can think of. As long as we have clients using our service Heliohost will continue to exist. 1 Link to comment Share on other sites More sharing options...
Recommended Posts