Could you install MySQL 4.1 and then upgrade it? Do you have any other backups of the DB? - Jamie <div>On 2/10/07, Matt Morgan <<a href="mailto:minxmertzmomo@gmail.com"> minxmertzmomo@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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 <a href="mailto:fedora-list@redhat.com">fedora-list@redhat.com</a> To unsubscribe: <a href="https://www.redhat.com/mailman/listinfo/fedora-list"> https://www.redhat.com/mailman/listinfo/fedora-list</a> </blockquote></div> -- Jamie Bohr