mysql server problem

[Simon Lee]

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.

Regards,
Simon

[Drakazz]

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 ( http://dev.mysql.com/ )

"Error: 1036 SQLSTATE: HY000 (ER_OPEN_AS_REA DONLY)

Message: Table '%s' is read only"

ER_OPEN_AS_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.

thanks!