MySQL corruption

RudeYute

This morning, I find that the database on one of my websites is causing problems. Long story short, it's corrupt. From what I gather this would be due to hardware problem on the host.... I'm annoyed, but won't go blaming them yet.

Anyway, according to the host, backups are daily, but are overwritten daily (now we're in trouble)... so we tried to restore the old database, but no joy... took the site totally offline. Ended up putting back the one from earlier, so we have a site which shows database errors all over it.

Now, using phpMyAdmin, I can see 71 tables in the database, but when I go to export them, I just get some HTML/Java and errors. Using MySQL, I can see the the database size as 0.91mb (might be alright). However, I take a backup using cPanel, and the database I get just shows the following:

Code: Select all

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

Nothing else (ie, no content).

I have an old backup from September which I am reluctent to use, but comparing them, there's a fair bit missing.

So I suppose my main question is, is it possible to repair the current one? I have tried the Check and Repair options in MySQL within cPanel.

And yes, I have learnt that I should take regular backups, but in my defense, I thought the host would have more than a day's worth... at very least a week.

Thanks