Showing posts with label wordpress. Show all posts
Showing posts with label wordpress. Show all posts

Thursday, May 23, 2013

Count how many times your Wordpress login page has been requested

With all of the hacking and botnet activity probing Wordpress sites the past few months, you might wonder how many times your Wordpress login page (wp-login.php) has been requested. Here's a command that you can run from the terminal prompt to see:

/home/user $ grep -c wp-login access.log
On my personal Wordpress site, I found the following results:
  • May 5th to 12th - 598 http requests 
  • May 12th to 19th - 7,555 http requests
  •  May 19th to 22nd - 55 http requests
Very interesting indeed.

Wednesday, April 10, 2013

Steps to upgrade Wordpress to latest version

Here are the steps to upgrade Wordpress to the latest version using SSH terminal.
  1. Download the latest version of Wordpress:
    http://wordpress.org/download/
  2. Backup Wordpress install:
    [/home/user/public_html] $ tar -cz wordpress > wordpress.tar.gz
  3. Backup MySQL database:
    [/home/user/] $ mysqldump --add-drop-table -h localhost -u username -p databasename > mysql-backup-datehere.sql
  4. Compress the sql backup file and store elsewhere:
    [/home/user/] $ tar -cz mysql-backup-datehere.sql > mysql-backup-datehere.sql.tar.gz
  5. Extract new Wordpress files overwriting existing files:
    [/home/user/] $ tar -zxvf wordpress-version.tar.gz
  6. Visit the Wordpress upgrade page and perform database upgrade:
    http://www.domain.com/wp-admin/upgrade.php
Fin.