Results 1 to 5 of 5
Thread: changing db files attrib..
-
01-05-2007, 06:18 PM #1WHT Addict
- Join Date
- Nov 2006
- Posts
- 153
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
-
01-05-2007, 06:33 PM #2WHT Addict
- Join Date
- Jun 2004
- Location
- San Diego, CA
- Posts
- 137
chmod 644 user.*
Matt Bloom
AngryHosting - Load balanced/redundant shared hosting solutions
-
01-05-2007, 06:43 PM #3WHT Addict
- Join Date
- Nov 2006
- Posts
- 153
Originally Posted by optikalus
for all tables following error occured
HTML Code:MySQL Error : Tables 'X' is read only Error Numbers : 1036
-
01-05-2007, 06:52 PM #4WHT Addict
- 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
-
01-06-2007, 02:20 AM #5Web Hosting Guru
- Join Date
- May 2006
- Location
- Teh Interweb
- Posts
- 314
chmod 666 user.*
[theBleeber@wht01] ~ $ cat .signature
cat: .signature: No such file or directory