Ok I searched and read for around a hour keyword question

[MarkP]

I want to edit some keywords....I cannot find where they are stored...it is to labor intensive to edit them thry the admin panel...I want to use My SQL to download into Excel or something else and re-upload. Which tables hold the keywords....I found the dict table but it only has a few keywords in it.

[Nibbler]

They are in the {prefix}_pictures table.

[MarkP]

Thanks for the quick reply!

Am I correct to assume I only edit that table then? What exactly does the dict table do?

[Nibbler]

Only edit that table (backup first) and then regenerate the keyword list from within CPG. It keeps a list of all keywords instead of having to read them from the db, process them, remove duplicates etc. each time they are needed.

[MarkP]

Thank you