Wordpress

Plugins

• wp-subtitle

Develop

sudo apt-get install  php5-mysqlnd-ms

REPL

php -a
define('WP_USE_THEMES', false);
require('./wp-load.php');
$loop = get_posts( 'numberposts=1' );

$subtitle = new WP_Subtitle( 185 );
var_dump( $subtitle->get_raw_subtitle() );

Move Wordpress

• move database
• move wp-content

• update wp_options set option_value='http://staging.annesque.com' where option_id in (2, 1);

  • that's for options 'siteurl' and 'home'
• cat 20180529_annesque_wp.sql | sed 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/' > out.sql
• chown www-data:www-data <the wp dir>
• sudo apt-get install php5-mysqlnd-ms
• sudo apt-get install libapache2-mod-php5

Troubleshoot

Wordpress plugin install: Could not create directory

sudo chown -R www-data:www-data ../../wordpress_webdevzine/

Trash

curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar
php wp-cli.phar theme activate FoundationPress

https://s3.amazonaws.com/ish-backups/wordpress/blogwasyaco.wordpress.2016-01-06.xml
php wp-cli.phar  plugin install wordpress-importer --activate
php wp-cli.phar import blogwasyaco.wordpress.2016-01-06.xml  --authors=create