wordpress

SELECT *
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL

DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL

# m h  dom mon dow   command
0,10,20,30,40,45,50,55 * * * * wget -q http://www.wordpresssite.org/cron.php > /dev/null && rm cron.php >/dev/null 2>&1

root@mercury:hn# find  /home/user/svn_co/me/project-name/ -type d -exec chmod 755 {} +
root@mercury:hn# find  /home/user/svn_co/me/project-name/ -type f -exec chmod 644 {} +
root@mercury:hn# find  /home/user/svn_co/me/project-name/public/wp-content/ -type d -exec chmod 775 {} \
> ;
find: missing argument to `-exec'
root@mercury:hn# find  /home/user/svn_co/me/project-name/public/wp-content/ -type d -exec chmod 775 {} \;
root@mercury:hn# find  /home/user/svn_co/me/project-name/public/wp-content/ -type f -exec chmod 664 {} \;

#!/bin/bash
#
# This script configures WordPress file permissions based on recommendations
# from http://codex.wordpress.org/Hardening_WordPress#File_permissions
#
# Author: Michael Conigliaro
#
WP_OWNER=changeme # <-- wordpress owner
WP_GROUP=changeme # <-- wordpress group
WP_ROOT=/home/changeme # <-- wordpress root directory
WS_GROUP=changeme # <-- webserver group

# reset to safe defaults
find ${WP_ROOT} -exec chown ${WP_OWNER}:${WP_GROUP} {} \;
find ${WP_ROOT} -type d -exec chmod 755 {} \;
find ${WP_ROOT} -type f -exec chmod 644 {} \;

# allow wordpress to manage wp-config.php (but prevent world access)
chgrp ${WS_GROUP} ${WP_ROOT}/wp-config.php
chmod 660 ${WP_ROOT}/wp-config.php

# allow wordpress to manage .htaccess
touch ${WP_ROOT}/.htaccess
chgrp ${WS_GROUP} ${WP_ROOT}/.htaccess
chmod 664 ${WP_ROOT}/.htaccess

# allow wordpress to manage wp-content
find ${WP_ROOT}/wp-content -exec chgrp ${WS_GROUP} {} \;
find ${WP_ROOT}/wp-content -type d -exec chmod 775 {} \;
find ${WP_ROOT}/wp-content -type f -exec chmod 664 {} \;