Re: mysqld wont start...

Jean-David Beyer wrote:
The Natural Philosopher wrote:

Any one know how to sort this?
Restore from backup?

P.S.: Also get a UPS on that machine so it will not happen again.

Not very helpful actually.

This is all locking the stable door..

True, but with a current backup and a UPS, it will be easier to recover
from, and will be less likely to happen. Prevention ...
Wondering if I could grab files from a working and similar setup..
OK..I managed to get things up and running: I had a REALLY old backup of
the initial installation.

I copied the offending files from that into the mysql database, and achieved connection, but had to recreate all the users..which wasn't too
hard since I had php scripts telling me what the names and passwords
were.


Basically the databsase must have been actually starting up when the power tripped.

So it mashed the important tables that control its operation.

The subsequent databases attached to it all seem OK. They would not have
been being accessed when it crashed.

Hope this helps someone else in similar predicament one day.

As do I. But none of it will matter because people will not do backups and
will not get UPSs, even when it happens so regularly.


The time taken to back up regularly exceeds the time I took to actually fix the pronblem, Jean.

Cost benefit analysis is my Occams razor in many cases.
.

Relevant Pages

  • Re: mysqld wont start...
    ... Restore from backup? ... Also get a UPS on that machine so it will not happen again. ... I copied the offending files from that into the mysql database, ... The time taken to back up regularly exceeds the time I took to actually ...
    (comp.os.linux.misc)
  • Re: Audacity and Gentoo
    ... > What's the UPS, btw? ... Still, a difference system would save a lot of space, unless database ... It would also be useful in case of data recovery as you'd at least be ... > Backup and Point-In-Time Recovery'). ...
    (uk.comp.os.linux)
  • Re: Backup failure with logfile
    ... I was being a little dramatic on the UPS. ... condition and caused the server to reboot serveral times. ... the Mozypro Internet Backup program going and also use SBS backup. ... SBS 2003 std. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Overnight Shutdown
    ... for now excluded this from the SBS backup and we are ... the event logs and found that the last application event during every shut ... Server is turned on. ... We originally thought it had something to do with our APC UPS but we ...
    (microsoft.public.windows.server.sbs)
  • Re: Backup plan help....
    ... > run raid 55 but oh well) I need a once nightly backup, ... > the scripts to do it, but would rather not as my shell scripting is a ... > MySQL database, the rest of the files change rarley. ... tar up the web pages from cron ...
    (linux.redhat)