Mike Telis Posted July 20, 2016 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
Tjoene Posted July 20, 2016 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.
Mike Telis Posted July 20, 2016 Author 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'
wolstech Posted July 20, 2016 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.
Mike Telis Posted July 20, 2016 Author 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 ...
wolstech Posted July 20, 2016 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.
wolstech Posted July 20, 2016 Posted July 20, 2016 @Krydos: Any chance we have a backup of mtelis_mant474 we can restore? Got lost in the crash...
Krydos Posted July 20, 2016 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.
Recommended Posts