repairing databases

Posted: Mon Jan 09, 2006 7:35 pm Post subject: repairing databases

Is there any way of automatically repairing a mysql database, say every 24 hours, or do you have to go into cpanel / mysql databases / repair manually?

NetHosted Staff Joined: 22 Mar 2004 Posts: 5651

Posted: Mon Jan 09, 2006 10:17 pm Post subject:

Because one of my sites (toonlist) is a postnuke one, and when I went in to have a ganders at the database it had a few errors. It wasn't correctly linking to a custom module, meaning that my Amazon referrals links weren't working. I know it's not a busy site, so I need ANY clicks I get to count.

I know it's the fault of the non-official module, and probably really badly coded by a complete amateur, but there's little I can do about that, not being a coder myself. Having it run a repair function every so often would help me and possibly make me the tiniest amount of money in the process.

NetHosted Staff Joined: 22 Mar 2004 Posts: 5651

You'd might be able to do it via a cron job using the MySQL command however my MySQL knowledge is limited and I can't see how you could do this right now.

Andrew

Posted: Tue Jan 10, 2006 9:47 am Post subject: DIY Neurosurgery

ToonlistGuy,

I'm not sure how you usually rate when filling in the risk assessment profile form with your local friendly IFA, but you may like to look at the MySQL utility program mysqlcheck

or, if that's not exciting enough, myisamchk

.

Both these utilities run from the shell prompt and you should therefore, as Andrew implies, be able to set them up as cron jobs.

However, I personnally would be very unhappy running this sort of utility without being able to see the output, either through an interactive shell or from a syslog. (By the same measure I would be even less enthusiatic running an application I knew to be corrupting my database, but hey, that's just me.) In this case therefore I would be more inclined to, at least initially, run the MySQL CHECK TABLE and REPAIR TABLE commands from within myphpadmin to maybe get a feel for what was really happening.

Good luck!

Pete

PS If you hadn't already guessed, any spare cash I have goes under the bed or into the building society.

Client Support	Community	Server Status	Contact Us	Client Login
Email Hosting	Website Hosting	Reseller Hosting	VPS Hosting	Dedicated Servers