I apologize if this is not the correct location to place this post ... I am desperate.
I discovered that my backup service was backing up my web directories, but not my mysql db's ... right after my hard drive crashed and I lost them.
I noticed that all that was remaining, was the innoDB ibdata1 file and the 2 logs ... even though I was using all myisam tables, it appears that this
was created anyways. Someone suggested the possibility of restoring the data from the 18G indata1 file, and I hope someone here could
possibly help me understand how to go about this, or if it is even possible.
Thanks a ton for ANY info that may help,
Jesse

Look in your backups under /var/lib/mysql ... stop the MySQL service, then copy back the databases you need ... change the ownership accordingly (mysql.mysql or root.mysql --- set it the same as the others) ... probably a good idea to copy the mysql database as well, since that's where all the permissions are ... and restart the service.

You'll prolly wanna run myisamcheck on them, too ... they're probably gonna be a little funky doing a hotcopy like that.