Simon Lee wrote:
> Dear all,
> I just reinstall the redhat 8. For convienience, I just copy all the data
> files from the old mysql server to the new one. Ao I give the same
> priviledge to it, .i.e. chown mysql.mysql and chmod 660, in order to give
> corresponding read/write authority. Also we give priviledge to the user in
> the mysql database. Anyway, when deleting some data from a table of the
> database, following error is given as
> ERROR 1036 : Table 'XXX' is read only.
You should always backup and restore the database with the mysql
functions! Then you won't run into this (and other) problems.
Looks like you copied the files while the server (either old or new) was
running. Try to recopy the files while the server isn't running. Set
your file permissions and ownership then restart the server.
If that doesn't work, I hope you have the old server still. Because you
will need to backup the database with the MySQL utils then restore them
on the new one.
And I never understood why people think they can just copy data files
for a relational database...
Remove the "x" from my email address
JDS Computer Training Corp.