joserg96 Posted April 13, 2018 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?
wolstech Posted April 13, 2018 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.
wolstech Posted April 13, 2018 Posted April 13, 2018 Lets see if our other root admin Krydos has a backup for it.
Krydos Posted April 14, 2018 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.
joserg96 Posted April 15, 2018 Author 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
wolstech Posted April 15, 2018 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.
Recommended Posts