whmxfer corrupt tables message

Malagana1

• November 25, 2015 12:47

After migrate a server I get this messages about a corrupted database:
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

• 

  cPanelMichael

  • November 25, 2015 19:35

  Hello :) Please post the output from the following command:
  mysqlcheck --repair whmxfer
  Thank you.

  0
• 

  Malagana1

  • November 26, 2015 00:06

  The command outputs the following:
  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
  

  0
• 

  cPanelMichael

  • November 30, 2015 20:17

  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.

  0
• 

  Malagana1

  • December 01, 2015 18:28

  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?

  0
• 

  cPanelMichael

  • December 01, 2015 21:54

  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?

  
  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.

  0

Please sign in to leave a comment.