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!

whmxfer corrupt tables message

Discussion in 'Database Discussion' started by Malagana1, Nov 25, 2015.

  1. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    After migrate a server I get this messages about a corrupted database:

    Code:
    whmxfer.accountlocal_clicsticomquick20150830064855ugkspww Error    : Table 'whmxfer.accountlocal_clicsticomquick20150830064855ugkspww' doesn't exist whmxfer.accountremoteroot_696439118copya201508300154039jlnojxs Error    : Table 'whmxfer.accountremoteroot_696439118copya201508300154039jlnojxs' doesn't exist whmxfer.accountremoteroot_696439118copya20150830071832wuyegukd Error    : Table 'whmxfer.accountremoteroot_696439118copya20150830071832wuyegukd' doesn't exist whmxfer.packageremoteroot_696439118copya201508300154039jlnojxs Error    : Table 'whmxfer.packageremoteroot_696439118copya201508300154039jlnojxs' doesn't exist whmxfer.queue_696439118copya201508300154039jlnojxs Error    : Table 'whmxfer.queue_696439118copya201508300154039jlnojxs' doesn't exist whmxfer.queue_696439118copya20150830071832wuyegukd Error    : Table 'whmxfer.queue_696439118copya20150830071832wuyegukd' doesn't exist whmxfer.queue_clicsticomquick20150830064855ugkspww Error    : Table 'whmxfer.queue_clicsticomquick20150830064855ugkspww' doesn't exist whmxfer.session_696439118copya201508300154039jlnojxs Error    : Table 'whmxfer.session_696439118copya201508300154039jlnojxs' doesn't exist whmxfer.session_696439118copya20150830071832wuyegukd Error    : Table 'whmxfer.session_696439118copya20150830071832wuyegukd' doesn't exist whmxfer.session_clicsticomquick20150830064855ugkspww Error    : Table 'whmxfer.session_clicsticomquick20150830064855ugkspww' doesn't exist
    How I can fix o get ride off this messages? The suggested fix is to do
    mysqlcheck but I get the same messages about tables missing
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    Please post the output from the following command:

    Code:
    mysqlcheck --repair whmxfer
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    The command outputs the following:

    Code:
    whmxfer.accountlocal_clicsticomquick20150830064855ugkspww
    Error    : Table 'whmxfer.accountlocal_clicsticomquick20150830064855ugkspww' doesn't exist
    status   : Operation failed
    whmxfer.accountremoteroot_696439118copya201508300154039jlnojxs
    Error    : Table 'whmxfer.accountremoteroot_696439118copya201508300154039jlnojxs' doesn't exist
    status   : Operation failed
    whmxfer.accountremoteroot_696439118copya20150830071832wuyegukd
    Error    : Table 'whmxfer.accountremoteroot_696439118copya20150830071832wuyegukd' doesn't exist
    status   : Operation failed
    whmxfer.packageremoteroot_696439118copya201508300154039jlnojxs
    Error    : Table 'whmxfer.packageremoteroot_696439118copya201508300154039jlnojxs' doesn't exist
    status   : Operation failed
    whmxfer.queue_696439118copya201508300154039jlnojxs
    Error    : Table 'whmxfer.queue_696439118copya201508300154039jlnojxs' doesn't exist
    status   : Operation failed
    whmxfer.queue_696439118copya20150830071832wuyegukd
    Error    : Table 'whmxfer.queue_696439118copya20150830071832wuyegukd' doesn't exist
    status   : Operation failed
    whmxfer.queue_clicsticomquick20150830064855ugkspww
    Error    : Table 'whmxfer.queue_clicsticomquick20150830064855ugkspww' doesn't exist
    status   : Operation failed
    whmxfer.session_696439118copya201508300154039jlnojxs
    Error    : Table 'whmxfer.session_696439118copya201508300154039jlnojxs' doesn't exist
    status   : Operation failed
    whmxfer.session_696439118copya20150830071832wuyegukd
    Error    : Table 'whmxfer.session_696439118copya20150830071832wuyegukd' doesn't exist
    status   : Operation failed
    whmxfer.session_clicsticomquick20150830064855ugkspww
    Error    : Table 'whmxfer.session_clicsticomquick20150830064855ugkspww' doesn't exist
    status   : Operation failed
    
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Do you have an entry for "lower_case_table_names" in your /etc/my.cnf file? If so, please remove it, restart MySQL, and let us know if the issue continues.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Indeed, I have "lower-case-table-names = 1". I have a host client who has a system that need the lower-case-table-names enabled to work. Could I remove the value then fix the error and enabled it again?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You could remove the value, repair the database, and then enable it again. However, note the better solution is to ensure the database that's requiring this value is updated to avoid the need for this setting.

    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