to 18hr old state after power outage
So basically all the changes from those 18hrs were stored in
logs and not yet commited to the database? So maybe if I
just commited the logs every so often I wouldn't have this problem?
It depends if you had any kind of query logging enabled
It depends if you had any kind of query logging enabled (binary or text)
.. If you started safe_mysqld with -l (that's text logging of queries) ..
or configured my.cnf with bin-log (that's binary logging)..
You should be able to pipe/patch the logs against the database and let it
run all the
So basically all the changes from those 18hrs were stored in logs and not
yet commited to the database? So maybe if I just commited the logs every
so often I wouldn't have this problem?
It depends if you had any kind of query logging enabled (binary or text)
.. If you started safe_mysqld
hi,
the power outage in ontario caused my server to crash. after i booted up
again it was as if the past 18 hrs never happened. all the changes to the
database were gone. is there anyway to recover the missing data? it's
probably too late now since new data has been put into the database
