Notes
To check the latest WordPress version:
curl -s https://wordpress.org/download/ |grep -Po 'The latest stable.+?\)'
Run where WordPress is installed:
cat wp-includes/version.php |grep "\$wp_version "
Mass check:
for i in `find . -name version.php`; do cat $i |grep "wp_version =" |cut -d"'" -f2; done find .… Read the rest
How to show WordPress admin user using mysql command prompt
select * from wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID where meta_value like '%administrator%';
or
SELECT u.ID, u.user_login, u.user_nicename, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id… Read the rest
By default WordPress runs its wp-cron.php too frequiently, so to change it:
Update wp-config.php with the following line:
define('DISABLE_WP_CRON', true);Setup manual cron job for wp-cron.php
Enter user’s crontab
crontab -lu USERNAME
And append command to run cron every 12 hours
0 */12 * * * cd /home/USERNAME/public_html; php -q wp-cron.php… Read the rest
For multisite WordPress version run the following commands:
mysql
use database_name;
SELECT * FROM wp_sitemeta where meta_key='site_admins';
This will also allow you to know which users can access plugins for management… Read the rest
The error's output like the following:
Error : Table 'XXXX_wrdp1.wp_comments' doesn't exist
mysql DATABASE_NAME;
DROP TABLE IF EXISTS wp_comments; CREATE TABLE wp_comments ( comment_ID bigint(20) unsigned NOT NULL auto_increment, comment_post_ID int(11) NOT NULL default '0', comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default '', comment_author_url varchar(200) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default '', comment_date datetime NOT NULL default '0000-00-00 00:00:00', comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', comment_content text NOT NULL, comment_karma int(11) NOT NULL default '0', comment_approved varchar(20) NOT NULL default '1', comment_agent varchar(255) NOT NULL default '', comment_type varchar(20) NOT NULL default '', comment_parent bigint(20) NOT NULL default '0', user_id bigint(20) NOT NULL default '0', PRIMARY KEY (comment_ID), KEY comment_approved (comment_approved), KEY comment_post_ID (comment_post_ID), KEY comment_approved_date_gmt (comment_approved,comment_date_gmt), KEY comment_date_gmt (comment_date_gmt) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
You may know about WordPress table's structure here:
http://codex.wordpress.org/Database_Description#Table:_wp_comments… Read the rest
It needs if you don't want to waste time to enable Shell Access for specific user to run some command from his shell
sudo -H -u someuser bash -c 'uptime'
Example of using:
cd ~someuser/www
curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar chmod +x wp-cli.phar… Read the rest
WP-CLI is a set of command-line tools for managing WordPress installations. You can update plugins, set up multisite installs and much more, without using a web browser
cd curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar chmod 755 wp-cli.phar mv wp-cli.phar wp mkdir wp_cli mv wp wp_cli echo "alias wp='~/wp_cli/wp'" >> ~/.bashrc… Read the rest
In order to view active plugins run:
mysql
use database;
SELECT * FROM wp_options WHERE option_name = "active_plugins";
From shell command line
mysql --host=localhost --user=database_user --password=dbpassword database -e 'SELECT * FROM wp_options WHERE option_name = "active_plugins";'
Save active plugins to file
mysql --host=localhost --user=database_user --password=dbpassword database -e 'SELECT * FROM wp_options WHERE option_name = "active_plugins";' |grep active_plugins |awk '{print $3}' > active_plugins.txt… Read the rest How to prevent your wordpress installation from overloading your shared server (or how to survive the digg effect on your wordpress blog):… Read the rest