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 server. 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.
+1
A:
common causes for this error:
- data files have the wrong permissions. have you checked who the owner is and what the permissions are?
- another mysql server instance is also using the same files and has them locked at the file system level.
- the tables are corrupted. try running REPAIR on the tables.
longneck
2009-10-14 20:25:24
yeah. just did a chmod 777 for now to make sure that's not the issue. also tried a chown mysql:mysql on it.
Trevor Hartman
2009-10-14 20:32:50
+1
A:
finally solved it:
sudo chown -R _mysql:wheel cf
restarted and now it works. (Leopard Server)
Trevor Hartman
2009-10-14 20:54:10