Moving Wordpress

3 Efficient Tools

Movе Piwik

Change Piwik administrator password with:

mysql --host=localhost --user=save-up-ch-piwik --password=Ezb17s#3 -e "USE save-up-ch-piwik; SOURCE bikeoch_piwik.sql;"

mysql --host=localhost --user=save-up-ch-piwik --password=Ezb17s#3

USE save-up-ch-piwik; 
UPDATE `piwik_user` SET `password` = MD5( '9xKftPQb' ), `token_auth` = MD5( CONCAT('admin', password)) WHERE `login` = 'admin' AND superuser_access = 1 ;


WordPress + CloudFlare’s Flexible SSL Without Infinite Redirect Loops - iControlWP

Nginx - How to set expires headers for images

Google PageSpeed

PageSpeed Configuration - PageSpeed Module — Google Developers

Pagespeed + Cloudflare

Page Speed and cloudflare - Google Search Is CloudFlare compatible with mod_pagespeed? – CloudFlare Support google - Is it sensible to use both pagespeed and cloudflare? - Server Fault Why I switched from Google Page Speed Service to Cloudflare ?

Wordpress knowledge resources

Another take on folders and submodule WordPress as a submodule and a project Darep/wordpress-boilerplate

When you need to debug

Get the gist:

wget https://gist.githubusercontent.com/jrfnl/5925642/raw/684479612fbf6d81cd440205f779ee25d3957710/wp-config-debug.php

Add this at the end of wp-config.php:

require_once(ABSPATH . 'wp-config-debug.php');

url rewriting - Rewrite all requests to index.php with nginx - Stack Overflow - http://stackoverflow.com/questions/12924896/rewrite-all-requests-to-index-php-with-nginx

Understand Caching in WordPress, Part 1: The Basics - WPMU DEV - http://premium.wpmudev.org/blog/understand-caching-in-wordpress-part-1-the-basics/

Extract specific table from full SQL backup

sed -n -e '/^DROP TABLE IF EXISTS `table_name`/,/^UNLOCK TABLES;/p' dump.sql > dump_table.sql

date 01. Jan 0001 | modified 28. May 2021
filename: Wordpress