Clean up old postmeta data

[splaquet]

i’ve searched and searched on the forum, but every admin response seems to avoid answering the actual question. (which I can partially understand, as the response could be detrimental to the inexperienced)

so, the question is… how do you safely and accurately clean out PRO, X & cornerstone entries in the database? as in, which meta_keys are SPECIFIC to those 3 items?

while we’re happily using Pro (and X) on dozens of websites, we migrated one of our shops to a much more advanced, Woocommerce theme.

our postmeta table is nearly 1gb in size (which kinda makes sense, as we have ~66k orders and ~45k customers)… but, i really need to trim some fat here.

Can you add/remove/help me build this list? Do you have ANYWHERE on your site that has this type of info, without having to look through the code for these themes/plugins?

_x_%
_cornerstone_%
_cs_generated%
_cs_template%
_cs_attachment%
_cs_preset%
x_demo_content

put that together, and you’ll get this:
select * from `wp_postmeta` where (meta_key like '_x_%') or (meta_key like '_cornerstone_%') or (meta_key like '_cs_generated%') or (meta_key like '_cs_template%') or (meta_key like '_cs_attachment%') or (meta_key like '_cs_preset%') or (meta_key like 'x_demo_content');

but, i’m fairly confident that i’m missing something here.

[tristup]

Hi @splaquet,

Thanks for reaching out.
There might be the builder data, generated CSS is included with those keys, and there is no such option available to delete those data. In case if you want to optimize the database please have a look at these articles.

14 Best WordPress Database Plugins (Clean and Optimize Your DB)

How to Optimize Your WordPress Database with One Click

Hope it helps.
Thanks

[splaquet]

well, i kind of expected that you would dodge the actual question, as that’s how ThemeCo’s response to all of the other similar posts/questions on here are addressed.

…so, are you saying that if we ever choose to move away from X or Pro, we’re never going to easily be able to remove all of the left over settings & options stored in the database? honestly, that really seems quite cruel of y’all.

in all fairness, not providing/sharing an accurate understanding of how your DB entries are stored is nearly as volatile as having us use one of the plugins listed above/in those links you shared. you know, as well as i, that as safe as those cleaners are, you’re never truly able to clean things out associated with a theme/plugin. and, with that, the only benefit i can see of why you’d pass us over to a third party cleaner would be to remove all responsibility from ThemeCo.

user clicks on one of those links, installs one of those cleaners, and wipes out a TON of data… all while the bulk of that data was actually being used.

as a lifelong advocate of X & Pro, i beg of you (as you have always been an amazingly professional company) to please provide some assistance in identifying the data leftover from moving away from X/Pro.

[christian]

Hey @splaquet,

We’re sorry for the confusion. My colleague didn’t dodge the question but misunderstood it.

We don’t have a list of database entries yet but I’ll post this case in our tracker as a feature request so maybe in the future, there might be a database cleanup option if you wish to move to another theme.

You’ll regretfully need to manually check the database entries. I know it would be tedious as you have lots of entries but there’s really no list we can provide you for now.

Thank you for understanding.