MySQL corrupt database?

[David_Horn]

Hi,

I think I might have a corrupt MySQL database. The script using it (phpAdsNew) takes forever to run (5 minutes per task) and it messes up my MySQL backup script.

I've tried runnin REPAIR TABLE EXTENDED but it didn't make any different, short of taking 20 minutes to run and frightening the life out of me 🙂

What I'd like to do is just fudge over the problem by renaming the database from phpads to xphpads so the backup script bombs out at the end of the backup rather than half way through.

I can't rename or move the contents to another database, though. The database is password protected and I get a login error even after I put the password in on the mysqldump command. I have root privileges on the server and databases. This is done through SSH.

If someone could give me a pointer here, I'd appreciate it. I'm a relative newbie when it comes to MySQL, so any help would be appreciated!

[Sxooter]

I'm no expert in these areas of MySQL, but I do think you want to have whoever runs that box run memtest86 on it for a day or two to prove if it's good or not.

If there's even a single bit error in memory it's one too many.

[David_Horn]

I own the box, so will have a go at running the memory test you say.

I'll report back the results in a while.