Using CentOS 6.4 x64.
Not sure what happened but somehow my VPS filesystem got corrupted and it is now in a permanent read-only state. I've been working with my hosting provider's sys. admin. but suffice it to say I can't run anything related to MySQL services or daemons.
I did however backup the contents /var/lib/mysql folder. I moved the DB directories from inside that to a new install of MySQL and did proper permissions and ownership. From there I was able to see the databases from the MySQL console and even view the tables but I couldn't get any further. Whenever I attempted to run a SELECT query on any of the tables I get "doesn't exist when using LOCK TABLES". Tried dumping the DB using skip-locks and all that but nothing seems to work. Select queries and any sort of dump seems to be useless.
Is there another way to repair or retrieve the contents of these tables/databases? Thank you.