Downtime and Recovery
Moderator: General Moderators
Downtime and Recovery
Update: From the wonderful people at ImHosted:
"We managed to rescue your forum back to the date "Thu Apr 22 - 2004".
The database was (315Mb) and took well over 1 hour to restore.
I have added a cron job on your server that will make a backup of your
main database (phpdn forums) every week. This is a direct
dump save so we won't have any partial backup issues."
Let me just say thank you to the great people at ImHosted. You guys rock. Thank you for the effort, and for keeping this great community alive (literally!).
-----
First: Obviously we are back. Minus a few posts, and minus a few members that the backup hadn't grabbed, but it's better the losing everything. Honestly, I don't know who recovered the system, whether it was Twig or someone else with ssh rights, or if it was ImHosted. I am inclined to say it was ImHosted, but I can't be sure. No one has sent me an email telling me.
Second: I am going to put together a backup and recovery plan. I had several people email me offering ideas and suggestions, and I will be looking into it. I will also be reviewing the MySQL manual. Most likely, I will document what I find so everyone (that means you!) can learn from this. We don't want this to happen again.
Third: I would like to thank everyone's support, assistance, and patience through this. It was most appreciated, it did indeed help.
Anyways, I will let you know more as I get clarifications, and once we have a solid backup and recovery plan, I will tell you what it is!
"We managed to rescue your forum back to the date "Thu Apr 22 - 2004".
The database was (315Mb) and took well over 1 hour to restore.
I have added a cron job on your server that will make a backup of your
main database (phpdn forums) every week. This is a direct
dump save so we won't have any partial backup issues."
Let me just say thank you to the great people at ImHosted. You guys rock. Thank you for the effort, and for keeping this great community alive (literally!).
-----
First: Obviously we are back. Minus a few posts, and minus a few members that the backup hadn't grabbed, but it's better the losing everything. Honestly, I don't know who recovered the system, whether it was Twig or someone else with ssh rights, or if it was ImHosted. I am inclined to say it was ImHosted, but I can't be sure. No one has sent me an email telling me.
Second: I am going to put together a backup and recovery plan. I had several people email me offering ideas and suggestions, and I will be looking into it. I will also be reviewing the MySQL manual. Most likely, I will document what I find so everyone (that means you!) can learn from this. We don't want this to happen again.
Third: I would like to thank everyone's support, assistance, and patience through this. It was most appreciated, it did indeed help.
Anyways, I will let you know more as I get clarifications, and once we have a solid backup and recovery plan, I will tell you what it is!
Last edited by jason on Tue May 11, 2004 10:25 am, edited 5 times in total.
- redhair
- Forum Contributor
- Posts: 300
- Joined: Fri May 30, 2003 4:36 pm
- Location: 53.23N-6.57E
- Contact:
http://www.phpclasses.org/browse/package/1560.html
MySQL is undoubtedly the most popular database used with PHP applications. Backup and restore a MySQL database is not always an easy task for owners of PHP sites, especially if they do not have shell access to the server machine or some other way to access the database server remotely,
This package uses several classes to provide an elegant Web interface for backup and restore MySQL databases to files.
The concern that the author had in generating compressed backup files to minimize the disk space requirements, demonstrates a certain level of maturity of this package.
-
randomblink
- Forum Commoner
- Posts: 51
- Joined: Wed Jan 28, 2004 11:27 am
- Location: Tulsa, Oklahoma, just this side of hell...
- Contact:
IT'S BACK!
Dear Sweet Lord...
I am just glad the damn site is back up! (he he, backup)
I about croaked the first day I popped back and tried to ask a question.
Is there a donation spot? I think next payday I will donate to say thanks... I didn't realize how much I rely on this site TILL I NEEDED IT AND IT WASN'T THERE!!!
You guys rock.
This is an informative site... Polite interactions (as much as should be expected of course)... Well structured... And it looks nice too...
Thanks!
I am just glad the damn site is back up! (he he, backup)
I about croaked the first day I popped back and tried to ask a question.
Is there a donation spot? I think next payday I will donate to say thanks... I didn't realize how much I rely on this site TILL I NEEDED IT AND IT WASN'T THERE!!!
You guys rock.
This is an informative site... Polite interactions (as much as should be expected of course)... Well structured... And it looks nice too...
Thanks!
No. And for certain reasons, I want to avoid making any direct money, or receiving any money for the site, so their probably won't be. Not that we need it, ImHosted hosts us for no fee, and in all truth, with no expectation in advertising (The banners on the site are completely here because I put them there, and was never asked to put them up). However, I might consider setting up a fund or something, non-profitish, and use the money for good things, like helping people in developing countries get computers, etc. Hrm, maybe I should consider getting non-profit status for PHPDN. ImHosted would probably like that, as it would mean they probably get a tax-break as well. And people donating would like that as well...hrm?Is there a donation spot? I think next payday I will donate to say thanks... I didn't realize how much I rely on this site TILL I NEEDED IT AND IT WASN'T THERE!!!
But I am also considering putting up a PHPDN Wishlist on Amazon, and use the Wishlist as a way for people to buy prizes that will be awarded to users of the forum. That way, you could buy something, and then we could send it to a user.
