Jump to content

MySQL and phpmyadmin.

archibald.horn
By archibald.horn
in Troubleshooting
 Share
Go to solution Solved by adam.mahony,

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.  On their web sites can find out more information about database recovery for mysql.  http://www.oemailrecovery.com/mysql_recovery.html

Posted

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.

Link to comment
https://linustechtips.com/topic/774087-mysql-and-phpmyadmin/#findComment-9771174
Share on other sites
Link to post
Share on other sites
Posted
  • Solution

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.  On their web sites can find out more information about database recovery for mysql.  http://www.oemailrecovery.com/mysql_recovery.html

Link to comment
https://linustechtips.com/topic/774087-mysql-and-phpmyadmin/#findComment-9771198
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Troubleshooting

×