MySQL Innodb recovery from restored files

After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue)

I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files for all the tables.  I can open the database using Navicat, but when trying to open individual tables the first attempt shuts down the MySQL service and after restarting it, table access attempts returns a message that the table doesn't exist.

I've uploaded the section of the error log from my last attempt to access the database.

I've contacted percona and am aware of their tools, and services, but was hoping someone could give me a little more insight to my issue, and if there is a way to restore this database that isn't a major time consuming pain in the butt. :)

Thanks,
David

Server issue specifics:

The server crash was the result of a power surge, which took out the SATA and RAID controllers. It also completely damaged one drive (there were 2 drives mirrored in RAID1 as dynamic disks). The other drive was only partially damaged, and it is from this drive that we extracted the files that we have from the mysql data directory (that is the "afriplexqms" directory you're seeing).

However, we also have a manual backup set, which is in the root of the D:\IRENE\TLM folder (in the form of 342 .sql files).
MySQL-Error-Log.txt
David SmithsteinCEOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
When the DB was "restored," Did the user restore from the filesystem backups?

If you have the SQL files dumps, you should try restoring that data on a separate system where you can install MYSQL if not installed and restore them from the sql dumps,
Hopefully, you have the DB/table create as part of the SQLs and the sql backups are recent enough.
The only time a filesystem mysql backup will be valid is when mysql is not running when the backup is taken/made/created.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.