The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql Always Restarting During Full Backup Restore

Discussion in 'Database Discussions' started by Naila, Jun 20, 2017.

  1. Naila

    Naila Registered

    Joined:
    Jun 20, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Indonesia
    cPanel Access Level:
    Root Administrator
    Hi all,

    On my server if run restore a full cpanel backup, first i always have this:


    Does it have to restart mysql or is this just a configuration error?

    Very uncomfortable because every restore backup cpanel, mysql down at least 1 minute to 2 minutes.


    Thank you for your guidance and assistance.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,163
    Likes Received:
    1,294
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    That's normal behavior when restoring an account, but MySQL taking 1-2 minutes to complete a restart is longer than expected. Does it take MySQL that long to restart when you restart it manually via the command line? How many databases do you host on the server?

    Thank you.
     
  3. Naila

    Naila Registered

    Joined:
    Jun 20, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Indonesia
    cPanel Access Level:
    Root Administrator
    Hello sir cPanelMichael,


    Cpanel account hosted on my server 300 account and have mysql approximately 200.

    Yes this is longer than the process of restarting mysql directly.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,163
    Likes Received:
    1,294
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Feel free to open a support ticket using the link in my signature so we can take a closer look to see why MySQL is taking longer than usual to restart when restoring databases/accounts on the server.

    Thank you.
     
  5. Naila

    Naila Registered

    Joined:
    Jun 20, 2017
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Indonesia
    cPanel Access Level:
    Root Administrator
    Hi sir Michael,

    I have opened ticket include mysql problem ticket ID #8635971
     
Loading...

Share This Page