Well, just like the site AllThingsmoto.com, Cafe Husky site is also toast.
http://www.cafehusky.com/account/alerts
http://www.cafehusky.com/account/alerts
Cafe Husky Server Crashed and Gone
- Thread starter Moto7man
- Start date
It can happen with any forum. A good hosting plan with daily backups is the usual way to prevent issues. If the site owner forgets to pay some of the important bills, the host can delete a site. A totally privately owned site relies on the quality of the hardware. Usually the worst case is losing a few days of content based on the most recent backup. It's easy for things to go poof in this electronic age ....... cue the end of the world movies. I often think we'd be better off without (anti)social media.
I do backups of the data on disk once a week and also a backup of the sql database on same interval. I store this off site on my personal google drive (cloud).
If disaster struck - At most, we would lose one week in posts...
They obviously didn't have a good backup routine in place on cafehusky...
There is an sql command to repair the database if it becomes corrupted. And I use that on occasion with good success - so I have never had to use the backup.
jeff
If disaster struck - At most, we would lose one week in posts...
They obviously didn't have a good backup routine in place on cafehusky...
There is an sql command to repair the database if it becomes corrupted. And I use that on occasion with good success - so I have never had to use the backup.
jeff
That's why the donations are so important.
Another thing to mention is that this site is quite old school where the web server is running at my home. It is a linux box running apache webserver and mysql database. We pay for internet connection with static IP address versus hosting/vps fees.
I have thought about moving it off - but I had trouble with one site off site where it had too much activity and slowed down a shared machine - they shut me down.
Searching and web crawlers will slow down a site - this one is pretty fast even though the machine is a little old. We have the entire CPU and entire memory to ourselves...
I talked to my friend Les and he told me that cafehusky owner dean died a few years back and then someone was able to get into his hosting company to keep it going for a while. Sounds like they had it limping along until it finally died....
jeff
I have thought about moving it off - but I had trouble with one site off site where it had too much activity and slowed down a shared machine - they shut me down.
Searching and web crawlers will slow down a site - this one is pretty fast even though the machine is a little old. We have the entire CPU and entire memory to ourselves...
I talked to my friend Les and he told me that cafehusky owner dean died a few years back and then someone was able to get into his hosting company to keep it going for a while. Sounds like they had it limping along until it finally died....
jeff
coopernicus
Platinum Level Site Supporter
Does mysql have a transaction log that can have a script run against it for db transactions in a specified date range? That way most transactions can be re-applied from the db backup as long as the transaction log dumps are also saved. A LONG time ago we used to rebuild Sybase from a db backup and re-apply transactions for our systems. We had storage limitations in the old days that necessitated that process. I don't know if RDBs are like that these days!
Yes. I'm old...
Yes, mysql logging is enabled. Never had to use it though - thank god... My understanding is that it can be used to restore to a point somewhere between the weekly backups...
jeff
