Backup your database daily

nitin — Thu, 07 Aug 2003 06:29:17 +0000

Hi,

On a related note, you may want to backup your database or at least important tables on a daily basis or any other better frequency that makes sense.

Table corruption, data loss is a very frequent issue we as webmasters have to deal with. So, precaution is better than cure.

Regards,
- Nitin

section31 — Fri, 01 Aug 2003 21:58:15 +0000

Yes...i'm almost sure its the server crapping out.

antoshka — Fri, 01 Aug 2003 21:57:42 +0000

that happened to me a couple of times on one server and the reason was frequent server crashes.

section31 — Mon, 28 Jul 2003 23:48:35 +0000

NO, I don't use any permanent.

Mark Hensler — Mon, 28 Jul 2003 06:52:13 +0000

I'm just curious. Are you using a lot of permanent connections? Or do you avoid them?

ROB — Mon, 28 Jul 2003 04:00:01 +0000

it happens. can't tell you exactly what caused it, but in my experience mysql shutting down improperly (such as a hard kill), the server crashing, or running out of disk space can corrupt tables.

99/100 times REPAIR TABLE tablename; will fix it.