Problem with database

Tobias Karlsson

• August 24, 2015 04:11

Hi I have end up whit this error when i try to optimize my database or repair it: Can't create new tempfile: '/var/lib/mysql/tokar86a_myabdllife/wp_bx16hhpmrb_links.TMM' MyISAM Table './tokar86a_myabdllife/wp_bx16hhpmrb_links' is marked as crashed and last (automatic?) repair failed any suggestions what i should do to avoid this things?

• 

  Tobias Karlsson

  • August 24, 2015 09:19

  My tables also look like this that the photo shows.

  0
• 

  cPanelMichael

  • September 01, 2015 14:35

  Hello :) Have you tried using the myisamchk utility to repair the tables? It's documented at:

  0
• 

  Tobias Karlsson

  • September 01, 2015 14:58

  yes i have and it works but i get back the problem lather when i optimize the table whit help of a wordpress plugin.

  0
• 

  cPanelMichael

  • September 04, 2015 04:37

  It's likely a good idea to investigate further to determine why the database tables are crashing. Are you noticing any error messages in /var/lib/mysql/$hostname.err before it happens? Is anything unusual happening on the server (e.g. sudden reboots)? Thank you.

  0

Please sign in to leave a comment.