Wordpress: Clean up tables / Limpiar tablas

/* Delete Spam Comments */ DELETE FROM wp_comments WHERE comment_approved = 'spam'; /* Delete Unapproved Comments */ DELETE from wp_comments WHERE comment_approved = '0' /* optimizing and clean up the wp_postmeta table */ SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL; DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL; /* delete sessions */ DELETE FROM wp_options WHERE option_name LIKE '_wc_session_%' OR option_name LIKE '_wc_session_expires_%' /* delet TRANSIENT expirados (Transients API allow developers to store information in your WordPress database with an expiration time. )*/ DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%'); DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient_%');
Limpia las tablas de datos innecesarios o vencidos /
Clean unnecessary or expired data tables

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.