开发者

mysql copy catalogue

My server's mysql settings got wiped out. I'd like to move a single catalogue (wordpress install, fyi) to another server where I have mysql running. I did an scp of the catalogue ("cf") under /var/mysql/ over to my new serv开发者_运维知识库er. Setup a user, granted all privs, everything showed up fine. I can browse the tables and their contents in my GUI. The only problem is: when I try to update a row on the new server, I get an error "Table 'wp_options' is read only". What's the best way to fix? Thanks.


common causes for this error:

  1. data files have the wrong permissions. have you checked who the owner is and what the permissions are?
  2. another mysql server instance is also using the same files and has them locked at the file system level.
  3. the tables are corrupted. try running REPAIR on the tables.


finally solved it:

sudo chown -R _mysql:wheel cf

restarted and now it works. (Leopard Server)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜