Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2006-11-16 23:16:08
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
How do databases get corrupt?
Just wondering… what causes damaged tables and can you prevent it? (other than make regular backups of course)
Last edited by els (2006-11-16 23:17:17)
Offline
Re: How do databases get corrupt?
Drugs and money :P. No idea, but I try to optimize my tables each time I backup.
Offline
Re: How do databases get corrupt?
It would be nice if there was a plugin that makes a backup of the db each time you log out … :)
Offline
Re: How do databases get corrupt?
> Just wondering… what causes damaged tables and can you prevent it?
As a user of shared hosting? You can’t. It’s the job of the people managing the (mysql-)server.
Offline
#5 2006-11-17 11:55:57
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: How do databases get corrupt?
…that makes a backup of the db each time you log out…
Well, there almost is.
Offline
#6 2006-11-17 12:37:31
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: How do databases get corrupt?
RedFox wrote:
It would be nice if there was a plugin that makes a backup of the db each time you log out … :)
I set up a cron job using automysqlbackup as mentioned by Bert in this thread
It maintains an archive of daily, weekly and monthly db backups – very convenient.
Cheers Martin
Offline
#7 2006-11-17 13:49:21
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: How do databases get corrupt?
Thanks for your replies guys! It’s a pity not every host allows cronjobs, and rss_admin_db_manager doesn’t work with every host. I am now gradually moving my sites to hosts that do offer shell access (because that’s what is needed I suppose?).
Offline
Re: How do databases get corrupt?
Els, if you don’t have cron access, phpMyAdmin would be your best bet for backups.
I would go with 2.8.2.4 on the downloads page, the 2.9 series is so new and they are still working out some issues.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
#9 2006-11-17 16:18:29
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: How do databases get corrupt?
hcgtv wrote:
Els, if you don’t have cron access, phpMyAdmin would be your best bet for backups.
Yes, that’s what I’m doing. It’s just that you have to remember to do it…
Offline
Re: How do databases get corrupt?
Els,
doesn’t your hosting control panel offers a way to create cron jobs thru a web-based panel?
If you have that option enable, you may combine that with this suggestion by the great hcgtv who knows everything out there in the virtual world.
Offline
#11 2006-11-17 16:58:55
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: How do databases get corrupt?
Thanks Maniquí. No, my host(s) for my own site and some of the first sites I made don’t (I didn’t even know then what cron meant, so I didn’t select them for that). I already had a look at Automysqlbackup and I’m sure going to use it where possible :)
Offline
#12 2006-11-17 21:53:50
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Offline