asked
MySQL database issue
I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.
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
You can still read this resource for more information on your issue.
http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx
You've been very kind in your efforts to help. Thanks for that. Solved!
20 People are following this question.
