joserg96 Posted April 13, 2018 Share Posted April 13, 2018 Hi, I'm having a "Table doesn't exist" error with some of the tables on my database. Is there a way to repair these tables or at least get a backup to recreate them? Link to comment Share on other sites More sharing options...
wolstech Posted April 13, 2018 Share Posted April 13, 2018 They were probably InnoDB tables that got lost during a crash a while back. This issue is why we highly recommend you use MyISAM whenever possible. We've lost InnoDB data countless times, but have never lost MyISAM tables in our 10+ years in operation. What's the database name containing these tables? We need that so we can check if a backup exists. Assuming we have a backup to give you (we attempted them prior to the repairs that caused the data loss but no guarantee they succeeded, backups are ultimately a user's responsibility here), you'll need to create a new database and restore the backup to fix them. Krydos can remove the current corrupt database if you wish as well, or you can just pick a different database name. Link to comment Share on other sites More sharing options...
joserg96 Posted April 13, 2018 Author Share Posted April 13, 2018 The database name is joserg96_ireport Link to comment Share on other sites More sharing options...
wolstech Posted April 13, 2018 Share Posted April 13, 2018 Lets see if our other root admin Krydos has a backup for it. Link to comment Share on other sites More sharing options...
Krydos Posted April 14, 2018 Share Posted April 14, 2018 The backup link has been emailed to your contact email address. I didn't drop the database because it sounds like some of the tables are myisam and they may have changed since the backup was created. You can either create a new database and restore the backup into it or let me know and I can drop the database. Make sure it's fully backed up if you do request a drop. Link to comment Share on other sites More sharing options...
joserg96 Posted April 15, 2018 Author Share Posted April 15, 2018 Thanks, I received the backup, now the problem is that I got an error message saying that I do not own the db when I tried to delete it but then it disappeared and I can't create it again because "it already exists", so if you could delete it for me it would be nice. Thanks again for sending the backup Link to comment Share on other sites More sharing options...
wolstech Posted April 15, 2018 Share Posted April 15, 2018 Yeah, you can't drop it. Krydos needs to drop it for you. In the meantime if you want, you can create a new DB with a different name and restore the database backup into it. Link to comment Share on other sites More sharing options...
Krydos Posted April 16, 2018 Share Posted April 16, 2018 The database joserg96_ireport has been dropped. Link to comment Share on other sites More sharing options...
Recommended Posts