Reseller Web Hosting Offers:

How can I Repair the Database in Dedicated Server ?

Dedicated Server have the option to repair the database . Need to choose the database and we are clicking the repair option then it will be repaired.


Share This Now: [addtoany]

Watch Reseller Hosting Video Tutorial



Procedure

Repairing the Database In Dedicated Server

To Repair the Database in Dedicated Server via WHM, please follow the below steps,

1. Login to the Dedicated Server WHM as root user.

2. Go to the path,

Home » SQL Services

3. Click the option “Repair a MySQL Database”

4. In that choose the database name which you want to repair and click
” Repair Database “.

5. Untilt the process complete wait in the same page.

Screen Shots

Refer Screen Shots

Troubleshooting FAQs

Dedicated Server WHM Troubleshooting FAQs

How do I Set Super Privilege for a particular MYSQL User

Solution: 

1. Login to WHM as root

2. Click on phpMyAdmin option under SQL Services
3. Click on users tab on the right side
4. Choose the alphabet under where the user is created.
For example : Click on A if the mysql user name starts with A [like admysql_mydb]
5. Click on Edit Privilege link against that user
6. Under Administration heading, check Super option and submit.

 

Downloads

Related Downloads

Related Articles

Dedicated Server Support Articles

How do I Change the Root Password of MySQL Server ?
How can I Access All the Database in Dedicated Server ?
How can I View the MySql Process in Dedicated Server ?
How can I Map Multiple users to the Database in the Dedicated Server ?