MySql Error 1036 Table is Read Only

[alexy]

MySql Error 1036 Table is Read Only

I was copying a folder (database) from mysql server running on windows to a new mysql server running on FreeBSD. When I opened my website this error happened

ERROR 1036: Table ‘xxxxx’ is read only

It took me a while because I didn’t know what’s going on. So anyone help me to resolve this problem.

Thanks.

 

[Alt]

I think you should do

chown -R mysql [table-dir]

 

[alexy]

Still the same. When I access my website it's still the same.

 

[SirDice]

Is it a MyISAM table or InnoDB?

Have a look in the MySQL error log, maybe the table is just corrupt and needs fixing.

 

[alexy]

Is it a MyISAM table or InnoDB? --M MyISAM :|

It's corrupt to be extract, but I was fixing to remain the same. Even, I was REPAIR, it still the same. So I was TRUNCATE it