How to replace values in WordPress DB using phpMyAdmin

by

I am trying to save a value in a cg_option row/field using phpmyadmin, however data is not stored correctly and when loaded again after saving, only part of data appears. Do I need to use a conversion function within phpmyadmin?

The row is theme_mods_[theme-name]

This is a sample of data contained in the field:

s:19:"thim_my_text_option"
s:0:""
s:30:"thim_display_login_menu_mobile"
b:0
s:25:"thim_body_secondary_color"
s:7:"#4caf50"
s:24:"thim_remove_query_string"
b:0
s:21:"thim_google_analytics"

5 Answers
5

The data is serialized.

In order to edit it, you need to unserialize it, edit, then serialize again, and save.

You can do that with PHP.

Check serialize and unserialize.

You can check this tool as well: serializededitor.com

Leave a Comment