database reverted to 18hr old state after power outage

[Brian Chan]

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 since
then...

I now also have errors with my database. I run myisamchk
/var/lib/mysql/*/*.MYI -e -o -r
and I get many errors such as:
Found block that points outside data file at 9464
or
Found block with too small length at 980; Skipped

Is there anyway I can resolve these errors?

Thanks,
Brian.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw