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?
     
    #1 USA_Webmaster, Feb 26, 2019
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,485
    Likes Received:
    187
    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...
    #2 GOT, Feb 26, 2019
    USA_Webmaster likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,476
    Likes Received:
    506
    Trophy Points:
    263
    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...
    #3 cPanelLauren, Feb 26, 2019
(You must log in or sign up to post here.)
Loading...
Similar Threads - Bulk Repair MySQL
  1. Azstats

    Bulk Redirecting Domain Names

    Azstats, Jul 10, 2019, in forum: General Discussion
    Replies:
    3
    Views:
    364
    cPanelMichael
    Jul 16, 2019 at 12:57 PM
  2. Arta Seyedzadeh

    How to bulk delete current redirects in cPanel

    Arta Seyedzadeh, May 11, 2019, in forum: General Discussion
    Replies:
    6
    Views:
    305
    cPanelLauren
    May 13, 2019
  3. captlid

    Bulk Add Parked Domains to One Account?

    captlid, May 1, 2019, in forum: Bind/DNS/Nameserver
    Replies:
    3
    Views:
    226
    cPanelMichael
    May 6, 2019
  4. jonh

    Bulk/transactional email suggestions

    jonh, Feb 18, 2019, in forum: E-mail Discussion
    Replies:
    4
    Views:
    174
    cPanelMichael
    Feb 19, 2019
  5. BobHoliday

    Bulk Editing User PHP-FPM YAML Files

    BobHoliday, Feb 8, 2019, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    279
    cPanelLauren
    Feb 8, 2019

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.
    Accept Learn More...
    Dismiss Notice