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.

whmxfer corrupt tables message

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

  1. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    5
    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:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    5
    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:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
  5. Malagana1

    Malagana1 Member

    Joined:
    Nov 25, 2015
    Messages:
    5
    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:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    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.
     
Loading...

Share This Page