Table ‘******’ is read only问题解决
把windows 2003下mysql的data里的数据库复制到Centos下的mysql的data里面,可以查看。但是当对该数据库进行写入操作时候出现错误提示:#1036 - Table ‘xxxxx’ is read only.
解决方法为设置文件权限，然后重启，代码如下：
#sudo chmod -R 777 /var/lib/mysql/XXXX(数据库名)
#sudo /etc/init.d/mysql restart
If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.
Comments
还没有评论。
发表评论