I've just moved from a Linux server to FreeBSD.
To transfer my databases I just copied the table files across.
I can SELECT ok from the tables, but when I try to INSERT, I get a "table is read only" error.
I have set ownership of the files and directories to mysql, and the permissions are currently 777 (!).
Can anyone tell me what I need to do to put the tables back to normal??
To transfer my databases I just copied the table files across.
I can SELECT ok from the tables, but when I try to INSERT, I get a "table is read only" error.
I have set ownership of the files and directories to mysql, and the permissions are currently 777 (!).
Can anyone tell me what I need to do to put the tables back to normal??