• 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