mysql server problem

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Dear all,

I moved all mysql database data to the new server Redhat 9. and set the
right of the files to be mysql.mysql (chown) and 660(chmod), and also grant
all privileges to the corresponding databases, However, when I delete some
rows of data, the error is prompted out
"ERROR 1036: Table 'xxx' is read only." Why?  Anyway, I create a another new
database and add some tables into it , Then the delete function is OK. It is
very strange that all privilege are the same when I compare those of all old
database with those just created. Please advise me how to solve the problem
on the old databases, thanks.


Re: mysql server problem

try 770 if anything. also, you should look in mysql database settings
if your user is allowed to modify table data!
You should use a good client ( )


Message: Table '%s' is read only"

This means that the database itself might nto allow you to access the
table's data.
This is not a php question at all.


Site Timeline