Toadfish Monastery

Open Water => Forum Stuff => Announcements => Topic started by: ivor on July 30, 2008, 01:26:12 PM

Title: Monastery Database Problem
Post by: ivor on July 30, 2008, 01:26:12 PM
I have to apologize.  I changed something in ISPConfig and the database was dropped.  Also it appears that the backup has been failing and I missed it.  I have no idea what caused this to happen but I will find out.  It looks like we lost all of the new stuff since the Monastery was moved to the new server.  I am soooo sorry and this won't happen again.

Sorry,
MB

Edit:
I do see what the problem was with the back up.  ISPConfig uses a different schema than the original.  When I changed the backup job I didn't select the new schema.  The back up job has been fixed and is working properly now.

In ISPConfig you can transfer a site to a reseller that doesn't have access to MySQL and when you do that the databases get dropped. 

Again, I am soooo sorry.  I'm just mortified.

Please forgive me!  :'(
Title: Re: Monastery Database Problem
Post by: Alpaca on July 30, 2008, 02:37:37 PM
No worries, MB. I'm pretty sure the important stuff will get resurrected sooner or later.
Title: Re: Monastery Database Problem
Post by: ivor on July 30, 2008, 02:40:19 PM
Quote from: Alpaca on July 30, 2008, 02:37:37 PM
No worries, MB. I'm pretty sure the important stuff will get resurrected sooner or later.

I sure hope so.  I feel so bad.
Title: Re: Monastery Database Problem
Post by: Bob in a quantum-state-of-faith on July 30, 2008, 02:48:38 PM
Quote from: MentalBlock996 on July 30, 2008, 02:40:19 PM
Quote from: Alpaca on July 30, 2008, 02:37:37 PM
No worries, MB. I'm pretty sure the important stuff will get resurrected sooner or later.

I sure hope so.  I feel so bad.

Dude!  It's not that important!  We will survive, the monastery will survive.   Please don't beat yourself up for something you had little control over-- even if you DO think it was somehow your "fault", it's not worth feeling bad about.

You do SO MUCH for the 'story, that you certainly have earned a goof-up or five,  without needing to feel bad about it.

Alpaca said-- the really significant stuff will re-post itself:  what's on the minds of the sibs that really matters is still on their minds.  The re-posting of that may in fact, improve the content and style....who can say?  ;D

We all realize you did not intend for this to happen (that would be a different thing, yes?).

Your talents are sooooooo appreciated-- really.

Stop feeling bad about what cannot be helped-- the past is past: unchangeable.  Concentrate on the now, and the future, which is changeable.

Here's a frosty-one, on me :toast:  you look like you could use one.



_______________________


In the future annals of the Monetary, the scholars will look back on these missing days/weeks as secret meetings, no doubt....or some scandal that needed to be covered up... :ROFL:

Title: Re: Monastery Database Problem
Post by: Aggie on July 30, 2008, 02:52:51 PM
Can we have a retroactive scandal? ;D

No worries MB - it's been pretty slow lately (posting rate - summer - not Monastery performance).  Didn't lose as much as we might have, and the important stuff should be backed up mentally.


You may have also kept me out of the Portsmouth Stocks, if I'm lucky. ;)
Title: Re: Monastery Database Problem
Post by: ivor on July 30, 2008, 02:54:32 PM
Thanks everyone.  If I had five goof-ups I just spent them all.  :'(

A retroactive scandal would be great.  What should it be?  A government coup?
Title: Re: Monastery Database Problem
Post by: Sibling Zono (anon1mat0) on July 30, 2008, 02:55:33 PM
All those posts... my post count! No, Nooooooo!
:mrgreen: :mrgreen: :mrgreen: :mrgreen:
No worries bud, it happens from time to time (and something tells me that it won't happen in a while... ;))
Title: Re: Monastery Database Problem
Post by: Bluenose on July 30, 2008, 03:23:11 PM
Those of us who work with computers have all had our own disasters.  I know it hurts.  I know you feel like its all your fault.  Just remember its very easy to look back with 20:20 hindsight and say "I should have done such and such".  It may even be true, we all know that when these things happen if we had just done that extra backup, or just done... <insert action of your choice>  You know the deal.  The thing is, you did not do this on purpose.  No one's life will be lost.  We will carry on and in a day or two we will have forgotten all about it.

I know how hard it is, how much there is to plan for and take care of.  There is so much of it, that it is only to be expected that occasionally something will be missed, or some mistake will happen.  It does not really matter.  We are after all only human.  I know you did not do this on purpose.  I also know that next time it will not happen at all.  We learn from our mistakes, it's what we call experience.  The only way to make no mistakes is to do nothing, and that's a mistake.

So good MB, please know that we accept your apology.  We still love you.  We still want you for our sysop.  Where would we be without you?  A lot the worse methinks.
Title: Re: Monastery Database Problem
Post by: Sibling Chatty on July 30, 2008, 03:48:48 PM
DOOD!!

A mess-up that I didn't perpetrate. :mrgreen: ;) :-*

AND!! A whole new deja vu thing available on every counting thread and two word story!!

How many times in ya life do ya get a free do-over? This will be fun!
Title: Re: Monastery Database Problem
Post by: Bob in a quantum-state-of-faith on July 30, 2008, 03:56:14 PM
I think a scandal is Just The Ticket.

We need to think of something really, REALLY juicy.

If we put our heads together, we can come up with something, yes?  ;D
Title: Re: Monastery Database Problem
Post by: Opsa on July 30, 2008, 04:46:09 PM
Still love you and are in total awe of you, MB!  :-*

The records will now show that we didn'blow so many guesses on Swato's Name That Movie game.

I say we go for a murder scandal. (I almost typed sandal!) Let's say we murdered a sandal and then tried to cover it up by wearing red patent leather stilletos. The murdered sandal has been buried in the catacombs. Now, all we have to do is make allusions to this murder all over the site and then try to cover it up.

Maybe every time someone mentions "feet" or "shoes" we can hustle along a change of subject.
Title: Re: Monastery Database Problem
Post by: Sibling Zono (anon1mat0) on July 30, 2008, 07:28:12 PM
Mmm... in those lost post is the evidence of such murder, who said what first? Who incriminated him/herself and his/her partners, but more importantly, how much did you got MB?
:mrgreen: :mrgreen: :mrgreen:
Title: Re: Monastery Database Problem
Post by: Griffin NoName on July 30, 2008, 07:35:58 PM
Hey, these things hapen. Think when it's banks losing all our money :mrgreen:

my only comment/ opinions is that an off-site backup is needed, as i mentioned before. They could restore it with minimal loss.

HAVE A THINK ABOUT THAT !

woops caps keep turning on sorry.

Can you tell me the date of the last NOT-lost posts??

Wouldn't your mirror have them?
Title: Re: Monastery Database Problem
Post by: Aggie on July 30, 2008, 07:42:26 PM
Quote from: Griffin NoName on July 30, 2008, 07:35:58 PM
my only comment/ opinions is that an off-site backup is needed, as i mentioned before. They could restore it with minimal loss.

Put me down for an off-shore backup of my bank account. :)
Title: Re: Monastery Database Problem
Post by: Swatopluk on July 30, 2008, 07:48:55 PM
I found some 18th July posts, so the losses must start behind that.
Title: Re: Monastery Database Problem
Post by: beagle on July 30, 2008, 08:31:03 PM
Quote from: Agujjim on July 30, 2008, 07:42:26 PM
Quote from: Griffin NoName on July 30, 2008, 07:35:58 PM
my only comment/ opinions is that an off-site backup is needed, as i mentioned before. They could restore it with minimal loss.

Put me down for an off-shore backup of my bank account. :)

I'll look after it for you and take it somewhere off shore.

Saw an interesting article on how sub-prime is spreading to prime. Apparently Americans who can afford to pay their mortgages are walking away too, because of the drop in house prices and negative equity. Maximum exposure of American banks to these losses, $1 trillion.   Total assets of American banks, $1.3 trillion .  Do your patriotic duty and nail an American to his/her porch tonight.


P.S. MB

For a first offence we generally just lop a hand off. Except we don't have anyone left who can handle an axe.
Title: Re: Monastery Database Problem
Post by: Sibling Zono (anon1mat0) on July 30, 2008, 08:45:43 PM
Quote from: beagle on July 30, 2008, 08:31:03 PM
Apparently Americans who can afford to pay their mortgages are walking away too, because of the drop in house prices and negative equity.
I know the case much better than I would like (my SiL's apartment is now worth less than half the price they paid for it), in fact my wife want's us to get involved ( :headbang: ). I don't even wanna know how much my apartment is worth now.  :'(
Title: Re: Monastery Database Problem
Post by: beagle on July 30, 2008, 08:50:55 PM
According to the Beeb, the ability to walk away is a consequence of laws brought in during the Great Depression.  Happens here too, but not on the same scale apparently (at least not up till now).
Title: Re: Monastery Database Problem
Post by: Griffin NoName on July 30, 2008, 08:59:19 PM
Quote from: Swatopluk on July 30, 2008, 07:48:55 PM
I found some 18th July posts, so the losses must start behind that.

Then I guess all we are mssing are Swato's totally unguessable Guess the Movie - and that has to be a good thing.  ;D :D :P :mrgreen:
Title: Re: Monastery Database Problem
Post by: beagle on July 30, 2008, 09:04:16 PM
Soon he'll realise we stopped going to the movies when they became talkies and choose ones for a more mature (well, old) audience.
Title: Re: Monastery Database Problem
Post by: Aggie on July 30, 2008, 09:17:09 PM
Quote from: beagle on July 30, 2008, 08:31:03 PM
Saw an interesting article on how sub-prime is spreading to prime. Apparently Americans who can afford to pay their mortgages are walking away too, because of the drop in house prices and negative equity. Maximum exposure of American banks to these losses, $1 trillion.   Total assets of American banks, $1.3 trillion .  Do your patriotic duty and nail an American to his/her porch tonight.

Hmph...  time to buy more SKF.  It's back in range, definitely going to jump in if it's below $115
Title: Re: Monastery Database Problem
Post by: beagle on July 30, 2008, 09:27:03 PM
I've still got shares in Lloyds TSB (Britain's most conservative and best-financed bank with no sub-prime exposure).  Not sure whether I'm mad for still having them or mad for not buying more now that their dividend is around 11%.
Neil Woodford (Britain's Warren Buffett equivalent) reckons it's still 6 months too early to buy banks, and his track record is somewhat better than mine.
Title: Re: Monastery Database Problem
Post by: Sibling Chatty on July 30, 2008, 10:35:02 PM
Quote from: Opsanus tau on July 30, 2008, 04:46:09 PM

I say we go for a murder scandal. (I almost typed sandal!) Let's say we murdered a sandal and then tried to cover it up by wearing red patent leather stilletos. The murdered sandal has been buried in the catacombs. Now, all we have to do is make allusions to this murder all over the site and then try to cover it up.

Maybe every time someone mentions "feet" or "shoes" we can hustle along a change of subject.

Griffin murdered the sandal because it wasn't the right color to go with her wedding ensemble for Second Son's Wedding. The red patent stilettos were to throw people off her track, as everybody knows women that are ill only wear sensible , granny-style orthopaedic shoes. ::) ::) :mrgreen:
Title: Re: Monastery Database Problem
Post by: Griffin NoName on July 30, 2008, 10:45:29 PM
Quote from: Sibling Chatty on July 30, 2008, 10:35:02 PM
Quote from: Opsanus tau on July 30, 2008, 04:46:09 PM

I say we go for a murder scandal. (I almost typed sandal!) Let's say we murdered a sandal and then tried to cover it up by wearing red patent leather stilletos. The murdered sandal has been buried in the catacombs. Now, all we have to do is make allusions to this murder all over the site and then try to cover it up.

Maybe every time someone mentions "feet" or "shoes" we can hustle along a change of subject.

Griffin murdered the sandal because it wasn't the right color to go with her wedding ensemble for Second Son's Wedding. The red patent stilettos were to throw people off her track, as everybody knows women that are ill only wear sensible , granny-style orthopaedic shoes. ::) ::) :mrgreen:

I think this is probaly :offtopic:, but for the sake of verity, I wore purple ballet style pumps. Flat for endurance; purple to pick up that colour in the dress fabric, and more importantly when I am old I shall wear purple - also they only cost £7 on mail-order and I enjoyed secretly being absolutely certain no one else would beat me for the "cheapest shoe" competition unfortunately they never had one[/]
Title: Re: Monastery Database Problem
Post by: ivor on July 30, 2008, 10:50:45 PM
Off-site backup would be great.  Any volunteers?  An on-site backup would have been great.

I had a really fun day at work fixing my bosses spaghetti code too.  I was pulling my hair out.

Everything since the 18th was lost thanks to ISPConfig, "on error drop database..."   ???  It's part my fault to for not verifying my backups.
Title: Re: Monastery Database Problem
Post by: Aggie on July 30, 2008, 11:07:43 PM
Quote from: beagle on July 30, 2008, 09:27:03 PM
Neil Woodford (Britain's Warren Buffett equivalent) reckons it's still 6 months too early to buy banks, and his track record is somewhat better than mine.

Good reason to stay double-inverse for a while, then.  This last little financial rally pushed prices to a discount relative to where I sold ($122, then sat and watched it top out about $200 before dropping back :P).
Title: Re: Monastery Database Problem
Post by: Griffin NoName on July 30, 2008, 11:31:58 PM
I could host an off site backup. Let me know total size* and I'll check out my web space - I've now got so many domains for projects that never happened (so far)  it is really sinful and a waste of the internet. ;)


..* and I guess projected growth - if only we could stop people posting ;D
Title: Re: Monastery Database Problem
Post by: ivor on July 30, 2008, 11:35:00 PM
It's about 45 Mb or so.  How would you do it?
Title: Re: Monastery Database Problem
Post by: Griffin NoName on July 30, 2008, 11:40:40 PM
Quote from: MentalBlock996 on July 30, 2008, 11:35:00 PM
It's about 45 Mb or so.  How would you do it?

Sounds easy peasy. Will check my webspace, when I recover from trip to Siberian Gulag.

Oh, how would I do it?

Daily fight to your home town. No probably not.

I don't know about Joomla without looking, or SMF, but phpBB3 is easy and I suspect the other two would offer similar.

Faling that I could set up a batch job. Not particularly attractive.

Sounds easy peasy. But, I will have to confirm.  ;) ;)
Title: Re: Monastery Database Problem
Post by: Bluenose on July 30, 2008, 11:53:14 PM
I would have thought that any backup would need to be initiated on the server running the database using a suitable agent, otherwise you would not get a consistant state if you tried to restore it.  MB, is it possible to get the database to create a local snapshot copy of itself at regular intervals and then perhaps we could run some sort of automated FTP job to export the snapshot to the remote location.  Just a thought and I do not pretend to fully understand the environment the Monastery is running in - that sort of stuff I usually refer to others.

Edit:  Actually, ideally you would want to only export changes, to keep net traffic down.  I don't know how to do this, I'm just the ideas guy!  :P
Title: Re: Monastery Database Problem
Post by: ivor on July 31, 2008, 01:08:21 AM
Really all you need is MySQLAdmin runnning on a machine some where.  You then set up a backup project to run daily.  The project need to use the "full backup" and "InnoDB" option for a consistent backup.
Title: Re: Monastery Database Problem
Post by: Alpaca on July 31, 2008, 01:11:33 AM
I've got more space than I know what to do with - I'd be happy to host a backup if you need me to.
Title: Re: Monastery Database Problem
Post by: ivor on July 31, 2008, 01:21:07 AM
Sounds Gouda!  Give me your IP address.  You've probably got a static IP but the first three octets will probably do.  The password is the same as the one I already gave you.  Let me know if you have any trouble.
Title: Re: Monastery Database Problem
Post by: Alpaca on July 31, 2008, 01:49:52 AM
75.126.127.218 seems to be it...
Title: Re: Monastery Database Problem
Post by: ivor on July 31, 2008, 01:58:43 AM
See if you can hit it.
Title: Re: Monastery Database Problem
Post by: Swatopluk on July 31, 2008, 08:42:02 AM
I am angry about the loss of the Haiku(s?) of the last two weeks and chapter 10 of the 2-word-story. The former had become really poetic and the latter achieved some kind of coherency. >:(
Title: Re: Monastery Database Problem
Post by: beagle on July 31, 2008, 08:58:26 AM
You might find them cached on Google if you can remember some of the text.
Title: Re: Monastery Database Problem
Post by: ivor on July 31, 2008, 09:08:20 AM
Quote from: Swatopluk on July 31, 2008, 08:42:02 AM
I am angry about the loss of the Haiku(s?) of the last two weeks and chapter 10 of the 2-word-story. The former had become really poetic and the latter achieved some kind of coherency. >:(

Sorry Swato.  I've verified the backup is running and Alpaca is looking to setup an off-site backup so this won't happen again.
Title: Re: Monastery Database Problem
Post by: Swatopluk on July 31, 2008, 02:05:25 PM
Quote from: beagle on July 31, 2008, 08:58:26 AM
You might find them cached on Google if you can remember some of the text.

We seem mostly invisble to google :(
Title: Re: Monastery Database Problem
Post by: Sibling Zono (anon1mat0) on July 31, 2008, 09:02:20 PM
Don't you get emails with updated threads? I bet both could be reconstructed from those emails.
Title: Re: Monastery Database Problem
Post by: Sibling Chatty on August 02, 2008, 05:03:34 AM
Swato, I look at it like this...<crosses eyes> :P

We've got the same weird and wonderful people here and we can build it better and stronger! We have the best looney minds in the universe, and we can do ANYTHING!! :woohoo: :faint: :idea: :pinkelephant: :bouncing:
Title: Re: Monastery Database Problem
Post by: Darlica on August 02, 2008, 09:08:15 AM
Quote from: Sibling Chatty on August 02, 2008, 05:03:34 AM
Swato, I look at it like this...<crosses eyes> :P

We've got the same weird and wonderful people here and we can build it better and stronger! We have the best looney minds in the universe, and we can do ANYTHING!! :woohoo: :faint: :idea: :pinkelephant: :bouncing:

"We have the best looney minds in the universe"

Maybe we should put that at our welcoming page... ;D
Title: Re: Monastery Database Problem
Post by: Griffin NoName on August 02, 2008, 05:26:56 PM
Quote from: Swatopluk on July 31, 2008, 08:42:02 AM
the 2-word-story......achieved some kind of coherency. >:(

Coherency, Yes.  Sanity, No.

I think we are benefitting from the Two-Word Story masterclasses and I'm sure our increasingly extensive experience is paying dividends. ;D

Perhaps we could hold a wake for some of the lost characters and events  :D
Title: Re: Monastery Database Problem
Post by: anthrobabe on August 04, 2008, 06:44:23 AM
Quote from: Darlica on August 02, 2008, 09:08:15 AM
Quote from: Sibling Chatty on August 02, 2008, 05:03:34 AM
Swato, I look at it like this...<crosses eyes> :P

We've got the same weird and wonderful people here and we can build it better and stronger! We have the best looney minds in the universe, and we can do ANYTHING!! :woohoo: :faint: :idea: :pinkelephant: :bouncing:

"We have the best looney minds in the universe"

Maybe we should put that at our welcoming page... ;D


Wait a minute--that is the title of my super secret diary!  ::)  and wouldn't it make a nice tee-shirt slogan.

Really MB it is alright-- we will live.
Title: Re: Monastery Database Problem
Post by: goat starer on August 04, 2008, 12:40:39 PM
I don't forgive you MB. If you are going to screw up then at least do it in a way that I notice. It is simply not good enough to mess up the monestary so subtly that my tiny mind does not even spot it. It makes me look foolish and unobservant.    ;)
Title: Re: Monastery Database Problem
Post by: Sibling Chatty on August 05, 2008, 01:15:55 AM
Silly Goat,

I bet you just thought you'd been sleep-nibbling again!
Title: Re: Monastery Database Problem
Post by: Griffin NoName on August 05, 2008, 02:00:19 AM
Sensible Goat. He will never see all the odd things that were said about him in obscure threads during that period. ;D
Title: Re: Monastery Database Problem
Post by: goat starer on August 06, 2008, 11:32:00 AM
i probably saw them but i blanked them from my mind due to their offensive content
Title: Re: Monastery Database Problem
Post by: Griffin NoName on August 06, 2008, 11:35:03 AM
Your mind? You have a mind?   :mrgreen:

I think we may be a little :offtopic: here.
Title: Re: Monastery Database Problem
Post by: Black Bart on August 15, 2008, 03:20:43 PM
Wot if all this had happened during Leonardo Da Vinci's Blue period?

We'd ave lost the Blue Mona Lisa and the Blue Madonna with the Big Boobies...oh...we HAVE lost em!
Title: Re: Monastery Database Problem
Post by: Griffin NoName on August 15, 2008, 03:24:52 PM

We've lost Cap'n BlueNose too - 'es gawn on 'is 'olidays, or so 'e sed.

The Blues allus seem to spell truble.
Title: Re: Monastery Database Problem
Post by: Black Bart on August 15, 2008, 03:30:13 PM
Well...lost seems a strong word for old Bluenose...he were never all there if ye arsks me! ;)