Difference between revisions of "Wordpress"
From Wasya Wiki
(→Move Wordpress) |
(→Move Wordpress) |
||
Line 21: | Line 21: | ||
* move database | * move database | ||
* move wp-content | * move wp-content | ||
− | * update wp_options set option_value='http://staging.annesque.com' where option_id in (2, 1); | + | * <pre>update wp_options set option_value='http://staging.annesque.com' where option_id in (2, 1);</pre> |
** that's for options 'siteurl' and 'home' | ** that's for options 'siteurl' and 'home' | ||
* cat 20180529_annesque_wp.sql | sed 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/' > out.sql | * cat 20180529_annesque_wp.sql | sed 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/' > out.sql |
Revision as of 21:04, 5 July 2018
Contents
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