Database restore

Post by **Steen Jakobsen** » Tue Nov 23, 2004 11:30 am

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

digger · Post by **digger** » Tue Nov 23, 2004 1:07 pm

……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

Guest · Post by **Guest** » Tue Nov 23, 2004 1:11 pm

that particular 'someone' seems to make a habit of moaning, ignore him

swingdingin · Post by **swingdingin** » Tue Nov 23, 2004 1:15 pm

i`ll second that digger

keep up the good work steen
mike

eviljock · Post by **eviljock** » Tue Nov 23, 2004 1:30 pm

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.

Post by **Steen Jakobsen** » Tue Nov 23, 2004 1:32 pm

Thanks for your understanding!

Post by **Steen Jakobsen** » Tue Nov 23, 2004 2:56 pm

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

Guest · Post by **Guest** » Tue Nov 23, 2004 7:27 pm

When you say Monday's posts are lost, should we re-enter any questions/topics that we had posted on Monday?

Post by **Steen Jakobsen** » Tue Nov 23, 2004 7:30 pm

I am afraid so

peterm · Post by **peterm** » Tue Nov 23, 2004 8:26 pm

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.

piglet · Post by **piglet** » Tue Nov 23, 2004 11:33 pm

Steen you do an excellent job

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

Post by **Steen Jakobsen** » Tue Nov 23, 2004 11:58 pm

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.

iane · Post by **iane** » Wed Nov 24, 2004 12:06 am

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

peterm · Post by **peterm** » Wed Nov 24, 2004 12:32 am

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.

Post by **Steen Jakobsen** » Wed Nov 24, 2004 12:44 am

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