cPanel has corrupt core MySQL tables - how to fix?

kpmedia

• November 09, 2015 03:09

Horde and Roundcube have corrupted tables from a botched VPS node maintenance (by the host). Also these: mysql.innodb_index_stats mysql.innodb_table_stats mysql.slave_master_info mysql.slave_relay_log_info mysql.slave_worker_info I can easily restore the daily backup for domains, but I'm not sure what to do here. Can cPanel simply be reinstalled on top of itself, to restore these tables? If so, what is the exact command?

• 

  redesignunit

  • November 09, 2015 09:08

  you need to repair your table using various command. first of all identify all corrupted tables using myisamchk
  # myisamchk /var/lib/mysql/bugs/*.MYI >> /tmp/myisamchk_log.txt
  then repair the corrupted table using myisamchk
  # myisamchk -r profiles.MYI
  Perform check and repair together for entire MySQL database
  # myisamchk --silent --force --fast --update-state /var/lib/mysql/bugs/*.MYI
  Allocate additional memory for large MySQL database
  # myisamchk --silent --force --fast --update-state \ --key_buffer_size=512M --sort_buffer_size=512M \ --read_buffer_size=4M --write_buffer_size=4M \ /var/lib/mysql/bugs/*.MYI
  Use myisamchk to get information about a table
  # myisamchk -dvv profiles.MYI
  

  0
• 

  kpmedia

  • November 09, 2015 09:25

  We're already past that stage. It's not a simple "fix it" command. The host said I need to reinstall the VPS. I'm hoping that I can simply reinstall cPanel on top of itself.

  0
• 

  Infopro

  • November 09, 2015 09:30

  Forcing a cPanel update might be an option worth trying, but reinstalling cPanel over top of itself, is not.

  0
• 

  anton_latvia

  • November 09, 2015 10:00

  Enter mysql console, select database, that has errors ("use databasename;") and try running "repair table_name;". If you are thinking about backup restore, you probably should only restore mysql, but if system tables are corrupt, you should fix them first. Force-mysql reinstall might help. If force reinstall would not help, I personally would delete broken mysql tables (or move to other folder), and try to recreate them manually and then restore all mysql backups. It's a tricky thing, but I don't see a reason, why whole VPS should be reinstalled.. It's MySQL problem, weird one, but what's wrong with VPS itself? Sounds more like "easiest thing to do" for the hoster.

  0
• 

  Infopro

  • November 09, 2015 10:16

  This post may be of some use: Horde problem: loops on login page

  0

Please sign in to leave a comment.