Permissions Help Needed
 

I screwed up my gallery so I copied just the gallery DB files. Tared them and copied them.

Now it sort of works but if I tried to edit anything it errors out saying the table is read-only.

When I try to optimize I get:


adv_gallery_permissionsOptimizeError: Table 'adv_gallery_permissions' is read only

How do I set the permissions to be write and read? It's just from the tables I moved physically.

Try:

AdminCP => Maintenance => Execute SQL Query

Or use phpMyadmin

Nope didn't do anything.

Also at command line I get:

mysql> alter table......
ERROR 1036 (HY000): Table 'adv_gallery_images' is read only

-rwxrwxrwx 1 mysql mysql 8592 Apr 1 04:17 adminutil.frm
-rwxr-xr-x 1 root root 464 Apr 4 21:47 adv_gallery_categories.MYD

How do I change the root to mysql?

When I do ls I get that.