Do You want a database restore from a backup? or a database corruption fix?
For the first case, you need a backup file generated before. if it's a mysqldump backup,
you need to execute the command line:
mysql -u root -p databasename < backupfilename
For the second case, you can execute the database/ table repair command:
REPAIR TABLE tbl_name [, tbl_name] ... [QUICK|EXTENDED]
Example
REPAIR TABLE table1, table2, table3 EXTENDED
It only works if you have the proper rights in that database.
If this method doesn't work then only try to recover the data by using MySql Recovery Toolbox. It is a qualitative tool that may help you. http://www.oemailrecovery.com/mysql_recovery.html