mysql recovery from server crash

[Guillermo Garron]

On 2/10/07, Matt Morgan <minxmertzmomo at gmail.com> wrote:
> My home server crashed recently. Some electrical problem that shorted
> the motherboard. The drives are fine, and I was able to recover files
> from them. But I can't figure out how to restore the mysql databases
> from the files in /var/lib/mysql.
>
> I think what I'm looking for is some mysql equivalent to MS SQL
> Server's "attach database" function. I don't think there is such a
> thing, or google and this list's archives might have helped.
>
> What I had was a Centos 4.2 server running mysql 4.1, I think. I only
> have one database that I need to restore. Since I can't bring that
> server up any more, I tried copying that db's data dir from the Centos
> disks to my Fedora Core 5 desktop. If I put that data dir in
> /var/lib/mysql on the Fedora Core 5 machine, mysql seems to recognize
> the DB but I can't really access it.
>
> Part of the problem may well be the shift from mysql 4.1 to 5 (mysql
> version in FC5); I don't know mysql well enough to know.
>
> What should I do to get this database back up? I only need to get it
> working well enough to dump it.
>
> Thanks,
> Matt
>
> --
> fedora-list mailing list
> fedora-list at redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>
Hi, I am also not good at MySQL just pair of months working with it,
but I could think maybe is a problem of permissions on the Database?

have you tried to use the command

GRANT ALL ON *.* TO ....
FLUSH PRIVILEGES

just guessing.

-- 
Guillermo Garron
"Linux IS user friendly... It's just selective about who its friends are."
(Using FC6, CentOS4.4 and Ubuntu 6.06)
http://feeds.feedburner.com/go2linux
http://www.go2linux.org