Results 1 to 5 of 5
  1. #1

    changing db files attrib..

    how can i change db files attributes (CHMOD ) using SSH ?

    for examle : files of user table in zode.sql

    how can i set their CHMOD 644 ?

    user.frm
    user.MYI
    user.MYD

  2. #2
    Join Date
    Jun 2004
    Location
    San Diego, CA
    Posts
    137
    chmod 644 user.*
    Matt Bloom
    AngryHosting - Load balanced/redundant shared hosting solutions

  3. #3
    Quote Originally Posted by optikalus
    chmod 644 user.*

    for all tables following error occured

    HTML Code:
    MySQL Error : Tables 'X' is read only 
    Error Numbers : 1036

  4. #4
    Join Date
    Jun 2004
    Location
    San Diego, CA
    Posts
    137
    make sure that the user running mysql (typically mysql) owns the file.

    chown mysql user.*

    if that doesn't work..

    chmod 666 user.*

    if that doesn't work, double and triple check the permissions for the user in your mysql.user and mysql.db tables.
    Matt Bloom
    AngryHosting - Load balanced/redundant shared hosting solutions

  5. #5
    Join Date
    May 2006
    Location
    Teh Interweb
    Posts
    314
    chmod 666 user.*
    Giving other write access to the db is not a great idea. It would be better if you found out the problem as it will likely creep up again.

    [theBleeber@wht01] ~ $ cat .signature
    cat: .signature: No such file or directory

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •