Reseller Web Hosting Offers:

How can I Repair the Database in Dedicated Server ?


Error: Your Requested widget " bcn_widget-2" is not in the widget list.
  • [do_widget_area colormag_advertisement_above_the_footer_sidebar]
    • [do_widget id="custom_html-10"]
    • [do_widget id="custom_html-11"]
    • [do_widget id="custom_html-13"]
    • [do_widget id="colormag_125x125_advertisement_widget-2"]
    • [do_widget id="text-15"]
    • [do_widget id="custom_html-9"]
    • [do_widget id="custom_html-12"]
  • [do_widget_area colormag_contact_page_sidebar]
    • [do_widget_area colormag_error_404_page_sidebar]
      • [do_widget_area colormag_footer_sidebar_four]
        • [do_widget id="custom_html-3"]
        • [do_widget id="text-7"]
      • [do_widget_area colormag_footer_sidebar_full_width]
        • [do_widget_area colormag_footer_sidebar_one]
          • [do_widget id="custom_html-6"]
          • [do_widget id="custom_html-7"]
          • [do_widget id="custom_html-8"]
          • [do_widget id="text-38"]
          • [do_widget id="text-3"]
          • [do_widget id="text-4"]
        • [do_widget_area colormag_footer_sidebar_one_upper]
          • [do_widget_area colormag_footer_sidebar_three]
            • [do_widget id="custom_html-4"]
            • [do_widget id="text-6"]
          • [do_widget_area colormag_footer_sidebar_three_upper]
            • [do_widget_area colormag_footer_sidebar_two]
              • [do_widget id="custom_html-5"]
              • [do_widget id="text-5"]
            • [do_widget_area colormag_footer_sidebar_two_upper]
              • [do_widget_area colormag_front_page_area_beside_slider]
                • [do_widget_area colormag_front_page_content_bottom_section]
                  • [do_widget_area colormag_front_page_content_middle_left_section]
                    • [do_widget_area colormag_front_page_content_middle_right_section]
                      • [do_widget_area colormag_front_page_content_top_section]
                        • [do_widget_area colormag_front_page_slider_area]
                          • [do_widget_area colormag_front_page_top_full_width_area]
                            • [do_widget id="text-17"]
                          • [do_widget_area colormag_header_sidebar]
                            • [do_widget id="custom_html-2"]
                            • [do_widget id="text-8"]
                            • [do_widget id="text-27"]
                            • [do_widget id="text-23"]
                          • [do_widget_area colormag_left_sidebar]
                            • [do_widget id="text-19"]
                          • [do_widget_area colormag_right_sidebar]
                            • [do_widget id="text-13"]
                            • [do_widget id="search-2"]
                            • [do_widget id="colormag_300x250_advertisement_widget-3"]
                          • [do_widget_area widgets_for_shortcodes]
                            • [do_widget id="breadcrumb_navigation_widget-5"]
                            • [do_widget id="text-16"]
                            • [do_widget id="text-20"]
                            • [do_widget id="text-24"]
                            • [do_widget id="text-25"]
                            • [do_widget id="bcn_widget-2"]
                            • [do_widget id="text-28"]
                            • [do_widget id="text-29"]
                            • [do_widget id="text-30"]
                            • [do_widget id="text-31"]
                            • [do_widget id="text-32"]
                            • [do_widget id="text-33"]
                            • [do_widget id="text-34"]
                            • [do_widget id="text-35"]
                            • [do_widget id="text-37"]
                          • [do_widget_area wp_inactive_widgets]
                            • [do_widget id="text-12"]
                            • [do_widget id="colormag_300x250_advertisement_widget-4"]
                            • [do_widget id="recent-posts-2"]
                            • [do_widget id="recent-comments-2"]
                            • [do_widget id="archives-2"]
                            • [do_widget id="meta-2"]
                            • [do_widget id="pages-3"]
                            • [do_widget id="text-22"]
                          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 ?