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.

Problem with database

Discussion in 'Database Discussions' started by Tobias Karlsson, Aug 24, 2015.

  1. Tobias Karlsson

    Tobias Karlsson Active Member

    Joined:
    Jul 29, 2015
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Sweden
    cPanel Access Level:
    Root Administrator
    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?
     
  2. Tobias Karlsson

    Tobias Karlsson Active Member

    Joined:
    Jul 29, 2015
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Sweden
    cPanel Access Level:
    Root Administrator
    My tables also look like this that the photo shows.
     

    Attached Files:

  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. Tobias Karlsson

    Tobias Karlsson Active Member

    Joined:
    Jul 29, 2015
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Sweden
    cPanel Access Level:
    Root Administrator
    yes i have and it works but i get back the problem lather when i optimize the table whit help of a wordpress plugin.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page