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.

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:
    6
    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.
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    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
     
  3. Grzeslaw

    Grzeslaw Well-Known Member

    Joined:
    Jul 11, 2006
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    6
    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 ?:>
     
Loading...

Share This Page