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!

Mysql privileges not transfering while transferring cpanel account to other server.

Discussion in 'Data Protection' started by zuberahmed1987, Mar 28, 2014.

  1. zuberahmed1987

    zuberahmed1987 Registered

    Joined:
    Mar 28, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi

    I am not able transfer cpanel account with proper mysql privileges for some accounts. after investigating I got following error in transfer log.

    Determining mysql dbs...DBI::db=HASH(0x8edb060)->disconnect invalidates 24 active statement handles (either destroy statement handles or call finish on them before disconnecting) at /usr/local/cpanel/Cpanel/Mysql.pm line 1373.

    Please find the success log for accounts moved correctly.

    Determining mysql dbs......mysql version: 5.1......mysqldump version: 5.1...Saving mysql privs...Done

    can you please suggest how can I fix this issue. I am getting this issue for those accounts having large no. of mysql users and mysql dbs.

    I have also tried /scripts/pkgacct but givig same error.

    Please help.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you let us know the contents of /etc/my.cnf on the server where you are attempting to package the account?

    Thank you.
     
    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