Page 1 of 1

Test post: MySQL crash

PostPosted: Thu Jan 01, 2015 11:32 am
by Brutman
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

Re: Test post: MySQL crash

PostPosted: Thu Jan 01, 2015 4:36 pm
by monzamess
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.

Re: Test post: MySQL crash

PostPosted: Thu Jan 01, 2015 4:44 pm
by Brutman
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.

Re: Test post: MySQL crash

PostPosted: Fri Jan 02, 2015 6:26 pm
by monzamess
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.