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!

problem with mysql on restored process from cpmove file

Discussion in 'Database Discussion' started by urgido, Aug 22, 2015.

  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    When an account is restored completely from WHM as root mysql service becomes inactive. I found many sites had problems connecting to mysql including my WHMCS system.

    This error only occurs when WHM is preparing to restore the backup cpmove.

    It's a normal issue?
    Anybody can confirm this as same problem?
     
    #1 urgido, Aug 22, 2015
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,813
    Likes Received:
    84
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Do you notice any specific error messages while restoring your account backup ? Please update here that logs, so that we can check it and assist you on this.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 24x7server, Aug 24, 2015
  3. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Thanks for your reply.
    You can perform this by yourself.
    Replicate these steps:
    1.- Restore an account from WHM as root.
    2.- In the restoring process, visit any website using mysql (you'll see connection problems to database)

    what log do you want?
     
    #3 urgido, Aug 24, 2015
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    16,242
    Likes Received:
    385
    Trophy Points:
    583
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    While the site is being restored there may be issues, yes.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 Infopro, Aug 24, 2015
  5. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Inclusive if the account with issues is not the restored? I restored aaa.com but bbb.com have mysql problems
     
    #5 urgido, Aug 25, 2015
  6. Suvrodeb

    Suvrodeb Registered

    Joined:
    Aug 20, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    rajshahi
    cPanel Access Level:
    Website Owner
    this is my same problem. please solve the problem.
     
    #6 Suvrodeb, Aug 26, 2015
  7. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Yeah!, this appears as a bug.
     
    #7 urgido, Aug 28, 2015
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,928
    Likes Received:
    1,819
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    What's the output to /var/lib/mysql/$hostname.err when this happens?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Sep 2, 2015
  9. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    117
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    My log is very large and I don't have the exact day of this issue. But if you want, you can try by yourself.
    If this occurs again I will update this thread
     
    #9 urgido, Sep 4, 2015
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,928
    Likes Received:
    1,819
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You can review /var/cpanel/accounting.log to determine when an account was created, and then search around that time in /var/lib/mysql/$hostname.err since you mentioned the issue happens when an account is in the process of restoring.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Sep 4, 2015
(You must log in or sign up to post here.)
Loading...
Similar Threads - problem mysql restored
  1. geokat

    Problem after mysql root password change

    geokat, May 17, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    302
    cPanelLauren
    Jul 16, 2018 at 10:10 AM
  2. jaheem

    Problem mysql restart in whm

    jaheem, Nov 3, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    868
    cPanelMichael
    Nov 3, 2017
  3. trucmuche

    permission problem since MySQL 5.6.37 update

    trucmuche, Sep 1, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    499
    cPanelMichael
    Oct 27, 2017
  4. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    555
    cPanelMichael
    May 4, 2017
  5. lifesecond

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,232
    cPanelMichael
    Mar 6, 2017

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