Am not a mysql db kinda guy... prefer the relational flavour ala postgres and pervasive. (pervasive costs money QQ). That doesn't mean I haven't used it, but I just haven't kept up.
What's the deal with ancient distro's?!? (Note, I have vendor box's that ship them with redhat 7.2... quite an upgrade from their version of 6)
If it's an old box, just keep the install and services to a minimum, but that's a different post and a different thread.
Say it with me, "It's recovery time!" (note, if you didn't say it before, I don't know how you got this far)
Ok, I have no idea where your mysql db files are located.
I'm going to ask the magic 8 ball...
He says, /var/lib/mysql/databasename
or you can du -a /mounted/location | grep dbname or worse just grep mysql
Now, if you are running the same version of mysql, you might get away with a copy operation. (copy the database folder to your new mysql database location) This is only going to work if the architecture remained the same, but if little has changed it could also possibly handle a small jump in mysql versions.
I dug up a handy reference for you for dumping and such. This might prove a bit helpful. Note, your old tools may not work with the libraries present since you went to a new version. The best strategy might be to fix what's broken.
http://dev.mysql.com/doc/mysql/en/up...g-to-arch.html
Of course, there is probably someone here more familiar with advanced recovery options in mysql. (between versions possibly as well).
Please post them some info on whats changed.