Mike Telis Posted July 20, 2016 Share Posted July 20, 2016 Hello, support! Could you please help me to restore access to Mantis DB? User name: mtelisMain Domain: mtelis.heliohost.orgServer: stevie Database name: mtelis_mant474. Error from MySQL query: DBD::mysql::db do failed: Unknown database 'mtelis_mant474'Failed to use mtelis_mant474: Unknown database 'mtelis_mant474' Thanks in advance! Mike Link to comment Share on other sites More sharing options...
Tjoene Posted July 20, 2016 Share Posted July 20, 2016 You will need to delete, recreate and assign the MySQL users to your database. Due to the MySQL crash, all the users were lost. This should solve the "failed to use ..." error. Link to comment Share on other sites More sharing options...
Mike Telis Posted July 20, 2016 Author Share Posted July 20, 2016 Unfortunately, it didn't help (or I done something wrong). I'm still getting the same error message: Error from MySQL query: DBD::mysql::db do failed: Unknown database 'mtelis_mant474'Failed to use mtelis_mant474: Unknown database 'mtelis_mant474' Link to comment Share on other sites More sharing options...
wolstech Posted July 20, 2016 Share Posted July 20, 2016 A missing/damaged user would give an access denied error. A failed to use message indicates that the database itself is missing. We had several (InnoDB-based) databases that got lost during the crash. Try restoring a backup to fix it. As always, we recommend using MyISAM as your storage engine since InnoDB is extremely sensitive to server failure, and can lose all of its data during a crash. Link to comment Share on other sites More sharing options...
Mike Telis Posted July 20, 2016 Author Share Posted July 20, 2016 I'm not a pro in this area ... could you please help me to fix it? Although I haven't used Mantis for a while I'd hate losing this archive ... Link to comment Share on other sites More sharing options...
wolstech Posted July 20, 2016 Share Posted July 20, 2016 Do you have a database backup of any kind? It'll be a .sql file usually made though cPanel or PhpMyAdmin. If you made a full backup in cPanel of your account at some point before the crash (end of May or earlier), I can explain how to extract your database from that. If you don't have a backup, I can check with Krydos to see if we have one, but we generally don't keep backups, so the odds of us having one are low. Link to comment Share on other sites More sharing options...
Mike Telis Posted July 20, 2016 Author Share Posted July 20, 2016 Unfortunately, I don't have a backup :-( Link to comment Share on other sites More sharing options...
wolstech Posted July 20, 2016 Share Posted July 20, 2016 @Krydos: Any chance we have a backup of mtelis_mant474 we can restore? Got lost in the crash... Link to comment Share on other sites More sharing options...
Krydos Posted July 20, 2016 Share Posted July 20, 2016 No, sorry. Like wolstech already said, we don't take backups of user's data. Users are expected to take their own backups. We do sometimes take backups of user's data prior to something like a mysql update, but unfortunately there was no way to know that mysql was going to crash prior to the event. For future reference we strongly recommend that everyone takes frequent backups of their site which can be accomplished using the tool in cPanel: http://stevie.heliohost.org:2082/frontend/x3/backup/index.html Another helpful tip is to use MyISAM storage engine for your mysql data. In our 11 years of operation we've never lost any myisam data. Twice now we've lost innodb data. Link to comment Share on other sites More sharing options...
Recommended Posts