rorymcdaniel

#!/bin/bash
for site in `wp site list --field=url`; do
   wp media regenerate --yes --url=$site
done
~     

magnetikonline

WordPress database clean up queries

• Orphan rows
  • wp_posts -> wp_posts (parent/child)
  • wp_postmeta -> wp_posts
  • wp_term_taxonomy -> wp_terms
  • wp_term_relationships -> wp_term_taxonomy
  • wp_usermeta -> wp_users
  • wp_posts -> wp_users
• Other

henrik

# Note: VAT identification numbers for Greece use "EL", not "GR".

COUNTRY_CODES_EU = %w[
  AT BE BG CY CZ DK EE FI FR DE GR HU IE IT
  LV LT LU MT NL PL PT RO SK SI ES SE GB
]