Difference between revisions of "Wordpress"

From Wasya Wiki
Jump to: navigation, search
(Move Wordpress)
(Move Wordpress)
Line 21: Line 21:
 
* move database
 
* move database
 
* move wp-content
 
* move wp-content
* <pre>update wp_options set option_value='http://staging.annesque.com' where option_id in (2, 1);</pre>
+
* <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
+
* <pre> cat 20180529_annesque_wp.sql | sed 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/' > out.sql </pre>
* chown www-data:www-data <the wp dir>
+
* <pre> chown www-data:www-data <the wp dir> </pre>
* sudo apt-get install  php5-mysqlnd-ms
+
* <pre> sudo apt-get install  php5-mysqlnd-ms </pre>
* sudo apt-get install libapache2-mod-php5
+
* <pre> sudo apt-get install libapache2-mod-php5 </pre>
  
 
== Troubleshoot ==
 
== Troubleshoot ==

Revision as of 21:05, 5 July 2018

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