Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Deleting the MYSQL tables :|

Discussion in 'General Discussion' started by Grzeslaw, Feb 27, 2007.

  1. Grzeslaw

    Grzeslaw Well-Known Member

    Joined:
    Jul 11, 2006
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Poland
    Hello

    From time to time, I have the very peculiar problem.
    Some users report me, that their sql tables has been broken
    The communique is: (for example)

    #1017 - Can't find file: 'LAM_security_role.MYI' (errno: 2)

    What could it be?
    What is the reason ?
    Anyone del it.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    4
    Trophy Points:
    193
    Location:
    Minneapolis, MN
    Make sure MySQL directory has the correct ownership and permission:
    chmod -R 0660 /var/lib/mysql/mysql
    chown -R mysql:mysql /var/lib/mysql

    Then, re-compile MySQL
    /scripts/mysqlup --force
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Grzeslaw

    Grzeslaw Well-Known Member

    Joined:
    Jul 11, 2006
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    158
    Location:
    Poland
    The folder /var/lib/mysql is olready owner by mysql.mysql recursively. Also the permissions for this folder are good [;

    What can it be ?:>
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice