Permissions Help Needed

[jfspam]

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.

[Zachariah]

Try:

AdminCP => Maintenance => Execute SQL Query

Content visible to verified customers only.

Or use phpMyadmin

[jfspam]

Nope didn't do anything.

[jfspam]

Also at command line I get:

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

[jfspam]

-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.