Page 1 of 2

Database restore

Posted: Tue Nov 23, 2004 11:30 am
by Steen Jakobsen
Please excuse the downtime on the forum. Last evening I had to shut down in order to restore to my latest back up copy (taken each evening at midnight), which unfortunately means that posts from yesterday were lost.

I know it is annoying and am doing my best to find the fault.

Steen

Posted: Tue Nov 23, 2004 1:07 pm
by digger
……annoying?….we can live with it
I don’t know if you saw some of the comments on here last night…some members were seemingly close to tears, and someone said the forum is badly managed…..well I for one believe you are doing your best Steen
Thanks, digger

Posted: Tue Nov 23, 2004 1:11 pm
by Guest
that particular 'someone' seems to make a habit of moaning, ignore him

Posted: Tue Nov 23, 2004 1:15 pm
by swingdingin
i`ll second that digger :!: :!:
keep up the good work steen
mike

Posted: Tue Nov 23, 2004 1:30 pm
by eviljock
As a slave in the computer industry, I know only too well how frustrating it can be when your database keels over for no apparent reason. Given that none of us are actually paying for this hitherto excellent service, I'll third that and say "thanks Steen". And if there's anything any of us can do to help track the cause, let us know.

Posted: Tue Nov 23, 2004 1:32 pm
by Steen Jakobsen
Thanks for your understanding!
:oops:

Posted: Tue Nov 23, 2004 2:56 pm
by Steen Jakobsen
Thanks Eviljock,

I think it is the sessions table/script messing things up, but nobody else using the same software seems to suffer the same problem.

Steen

Posted: Tue Nov 23, 2004 7:27 pm
by Guest
When you say Monday's posts are lost, should we re-enter any questions/topics that we had posted on Monday?

Posted: Tue Nov 23, 2004 7:30 pm
by Steen Jakobsen
I am afraid so

Posted: Tue Nov 23, 2004 8:26 pm
by peterm
Steen I was going to ask you what exactly has gone wrong. I might be running a forum for someone and I always thought phpbb+mysql just worked. Clearly not. Is it the software or the computer it is on?

By the way, by badly managed I meant in a technical sense, i.e. it doesn't work, rather than 'this person doesn't know his job'. I'm not in a position to comment on that one way or the other.

Guest (these guest oiks can't All be the same person can they?)
If I was running this or any other forum and it did what this one has been doing recently, I would quite rightly expect an earful from a lot of people. Whether I was actually getting paid directly for it or not. If I took your attitude to my customers, I wouldn't have any.

Posted: Tue Nov 23, 2004 11:33 pm
by piglet
Steen you do an excellent job :D

The site has been really useful and I definately had withdrawal systems when it was gone :cry:

Posted: Tue Nov 23, 2004 11:58 pm
by Steen Jakobsen
Hi Peterm,

phpBB have been running for nearly 2 years without any problems (27.800 articles) if I knew what was wrong I could have it fixed. I suspect it is the sessions table being corrupted somehow, ...probably by the silly guest remarks :-) - this said you still need to apply security updates etc.

I can only recommend phpBB - and we should all be thankful to the good developers who spend an incredible amount of time on open source projects like PHP, phpBB, Apache server, Linux, MySQL etc. without them the software market would not allow to develop small sites as the one we share here.

Posted: Wed Nov 24, 2004 12:06 am
by iane
Steen

At the risk of sounding sycophantic - I dont see why there is any negative comment coming your way about the site problems.

Thanks for all you do to keep the site operating - I appreciate it even if others don´t.

I have been involved on the "periphery" of computer system growth for some years now and I understand that things don´t always go as you hope.

Boa sorte :)

Posted: Wed Nov 24, 2004 12:32 am
by peterm
Steen, do you need to spend much time fiddling when the forum is running normally or is it backups + occasional updates? When I said 'I might be running a forum' I meant I might suggest it to the customer, if its going to involve me in a lot of work, I might keep quiet.

Posted: Wed Nov 24, 2004 12:44 am
by Steen Jakobsen
Peterm,

As I wrote; nearly two years without a glitch - who am I to complain? As a security measure I back up all my databases every 24 hours, it is the first time I have to restore.

The only stress is to safe keep 500 unique daily visitors joined efforts over two years
:-)