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.

problem with mysql on restored process from cpmove file

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

  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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,308
    Likes Received:
    45
    Trophy Points:
    28
    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.
     
    #2 24x7server, Aug 24, 2015
  3. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    15,419
    Likes Received:
    285
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    While the site is being restored there may be issues, yes.
     
    #4 Infopro, Aug 24, 2015
  5. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    35,630
    Likes Received:
    1,136
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

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

    Thank you.
     
    #8 cPanelMichael, Sep 2, 2015
  9. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    35,630
    Likes Received:
    1,136
    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.
     
    #10 cPanelMichael, Sep 4, 2015
(You must log in or sign up to post here.)
Loading...
Similar Threads - problem mysql restored
  1. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    123
    cPanelMichael
    May 4, 2017
  2. lifesecond

    Problem with Remote mysql

    lifesecond, Mar 4, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    356
    cPanelMichael
    Mar 6, 2017
  3. Masimo

    Mysql overload problem

    Masimo, Nov 20, 2016, in forum: Workarounds and Optimization
    Replies:
    6
    Views:
    377
    Masimo
    Nov 24, 2016
  4. Sebastian Sivori

    Mysql problem sql_mode WHMCS

    Sebastian Sivori, Jul 20, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    391
    cPanelMichael
    Jul 20, 2016
  5. Rafael Martins

    Problemas com o MYSQLI

    Rafael Martins, Jun 30, 2016, in forum: Discussões em Português
    Replies:
    2
    Views:
    534
    cPanelMichael
    Jun 30, 2016

Share This Page