MySQL database issue
MySQL database issue
FrankKelly
Posts: 1Questions: 1Answers: 0
I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.
This question has accepted answers - jump to:
This discussion has been closed.
Answers
Could you clarify what this has to do with DataTables? This is a forum for the DataTables JS library, not a cPanel or phpMyAdmin forum.
Allan
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
Thanks for your reply KristofLakatos, however, this still has nothing to do with DataTables. I'm going to close this thread. StackOverflow is a better place for non-DataTables discussions.
Allan