plugins - Mass SQL Wordpress Meta Key deletion

admin管理员组

文章数量:1277290

hi i am newbie with SQL data base so forgive my dumbness i have installed KK Star rating plugin on my wp site which noticed its recording lot of entries and my db size is over 280 MB and 188MB is wp_postmeta table. uninstalled the plugin and i want to run sql query to delete all postmeta with kkstar recorcs. the meta key record is: kksr_fingerprint_default so please give me correct command line to run thanks in advance

hi i am newbie with SQL data base so forgive my dumbness i have installed KK Star rating plugin on my wp site which noticed its recording lot of entries and my db size is over 280 MB and 188MB is wp_postmeta table. uninstalled the plugin and i want to run sql query to delete all postmeta with kkstar recorcs. the meta key record is: kksr_fingerprint_default so please give me correct command line to run thanks in advance

• plugins
• post-meta
• mysql

Share Improve this question asked Oct 15, 2021 at 13:52 Persian PrincePersian Prince 1333 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 2

DELETE FROM `{PREFIX}post_meta` WHERE meta_key = 'kksr_fingerprint_default'

{PREFIX} is the string $table_prefix defined in wp-config.php; of course be careful in run SQL DELETE, create a table backup and (maybe) execute first a single line deletion to check the result

DELETE FROM `{PREFIX}post_meta` WHERE meta_key = 'kksr_fingerprint_default' LIMIT 1 

First, make sure you back up your database. :)

If you're wanting to run a SQL command directly - perhaps using phpMyAdmin - the query would be

DELETE FROM wp_postmeta WHERE meta_key = 'kksr_fingerprint_default'

本文标签： pluginsMass SQL Wordpress Meta Key deletion