El Domingo, 11 de Febrero de 2007 04:48, Matt Morgan escribió: > 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. > In this kind of situations you think..."ummm, why the hell I didn't use mysqldump at least once a week" -- Manuel Arostegui Ramirez. Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues.
