[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

mysql and read-only errors

i'm trying to do an insert/update on a table and it gives me the error:

table 'mytable' is read only (State:S1000, Native Code: 40C)

i'm running linux and i'm pretty sure i have the permissions set up correctly.  (I've set up my user to have all priviledges on all databases).

anyone have this problem before?

0
bobbit31
Asked:
bobbit31
  • 3
  • 2
1 Solution
 
objectsCommented:
What user are you logging in to the database with?
What are the permissions granted to this user for mytable?
0
 
bobbit31Author Commented:
a user i set up with all permissions, i've even tried with root.
0
 
bobbit31Author Commented:
i've figured it out... basically i'm switching from NT to Linux and stupidly i just copied over the database files.  It let me read them ok so i figured that the transfer went ok.  But that's what screwed it up.  Basically to fix i did a mysqldump and then mysqlimport and everything is fine now.  
0
 
objectsCommented:
Your unix perms are seperate from your db perms.
0
 
bobbit31Author Commented:
i've already figured it out, but since i get eekpro for free the points are yours... thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now