Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Bulk Repair MySQL Database

Discussion in 'Database Discussion' started by USA_Webmaster, Feb 26, 2019.

  1. USA_Webmaster

    USA_Webmaster Well-Known Member

    Joined:
    Dec 10, 2015
    Messages:
    48
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    How do I bulk run repair tool in WHM or even cPanel? I thought I could do it in WHM, did I overlook it? When I tried using CTRL to multiple select, it was not allowed.
    Might you know of a workaround tip to select multiple databases and run repair tool?
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,351
    Likes Received:
    143
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    I don't know of a way in whm but from command line you can run

    mysqlcheck --all-databases -A

    And that will check and repair all tables in all databases.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    USA_Webmaster likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,716
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @USA_Webmaster

    The suggestion provided by @GOT is the most efficient, you can access all databases through WHM>>SQL Services>>PHPMyAdmin and you can repair databases from WHM>>SQL Services>>Repair a MySQL database but neither of these allow for bulk repair.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice