Test post: MySQL crash

Post here for administrative stuff

Test post: MySQL crash

Postby Brutman » Thu Jan 01, 2015 11:32 am

There was a minor problem with one of the database tables this morning that was killing the forum. I think I've fixed it, and I've made a backup copy of the database tables just to make sure that we don't lose anything precious.

Of course, a backup is useless if you haven't tested it. ;-0


Mike
Brutman
Site Admin
 
Posts: 952
Joined: Sat Jun 21, 2008 5:03 pm

Re: Test post: MySQL crash

Postby monzamess » Thu Jan 01, 2015 4:36 pm

I've experienced an intermittent issue with the sessions table being corrupted on my phpBB installation (corrected via the repair operation).

A while back my site was on the hit list for script kiddie hackers and once cleaning up their messes and tightening things down, I set up a cron job to perform a nightly database dump.
monzamess
 
Posts: 44
Joined: Sat Aug 14, 2010 7:16 am

Re: Test post: MySQL crash

Postby Brutman » Thu Jan 01, 2015 4:44 pm

In all of these years I've never had the session table get corrupted. And the repair procedure was easy, but not easy to find - I had to find my way into a control panel that would let me execute arbitrary queries. But it seems to have worked, so no real complaint.

Define "database dump" for me ... my only option seemed to be to run an export operation, which created a large number of create table and insert statements. I really hope that the import operation doesn't just involve running that mess of garbage; I have little faith in it. A nice file copy would have made me happier. (This is a shared host, so I'm probably not going to get that level of control.)

I've been trying to do things to make the board more reliable. Google has been running the email for brutman.com for a few months now, which should get around the various blacklists that this particular shared host gets on. The blacklists did not affect board operations too much but it did prevent "You have a new message" type emails from getting sent. And recently I moved the domain registration over to Google too which gives me their infinitely superior DNS servers.
Brutman
Site Admin
 
Posts: 952
Joined: Sat Jun 21, 2008 5:03 pm

Re: Test post: MySQL crash

Postby monzamess » Fri Jan 02, 2015 6:26 pm

Yep, that's it, quite literally "mysqldump" and as you've surmised, the restore operation is to run the SQL created by it. I haven't had problems with the rare event I've restored from the dump, but Google shows others have had problems with it. Better than nothing anyway.
monzamess
 
Posts: 44
Joined: Sat Aug 14, 2010 7:16 am


Return to Forum Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron