AidHamza

[example.org]
listen = /srv/vhtdocs/example.org/log/.php-fpm.sock
listen.owner = example_org
listen.group = www-data
listen.mode = 0660

user = example_org
group = example_org

pm = dynamic

AidHamza

UPDATE wp_options SET option_value = replace(option_value, 'http://servier.appsdoc.com', 'http://www.jambeslegeres.ma') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://servier.appsdoc.com','http://www.jambeslegeres.ma');

UPDATE wp_posts SET post_content = replace(post_content, 'http://servier.appsdoc.com', 'http://www.jambeslegeres.ma');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://servier.appsdoc.com','http://www.jambeslegeres.ma');

AidHamza

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

AidHamza

All credit: http://stackoverflow.com/questions/4006324/how-to-atomically-delete-keys-matching-a-pattern-with-redis

redis-cli [options] KEYS "prefix:*" | xargs redis-cli [options] DEL

AidHamza