This web page requires JavaScript to be enabled.

Apparently "noscript" tag content shows up in Facebook snippets ;)

How to enable JavaScript?

Maintaining a WordPress Database – Elementarray

Maintaining a WordPress Database

This is a quick example for maintaining a MySQL WordPress database. Use with caution! Only if you know what you are doing! You may use these commands in phpmyadmin if you have access. Replace “loc” with your database table prefix (which is usually “wp”)


/* deleting orphaned post meta */
DELETE loc_postmeta FROM loc_postmeta WHERE NOT EXISTS ( SELECT * FROM loc_posts WHERE loc_postmeta.post_id = loc_posts.ID )
/* deleting particular post meta */
DELETE loc_postmeta FROM loc_postmeta WHERE loc_postmeta.meta_key = "meta-checkbox"
DELETE loc_posts FROM loc_posts WHERE loc_posts.post_title = "Auto Draft"
DELETE loc_postmeta FROM loc_postmeta WHERE loc_postmeta.meta_key = "_edit_lock" OR loc_postmeta.meta_key = "_edit_last"
0

Leave a Reply

en_USEnglish