Using wget to download HTML website

Replace with the website you want to download files from.

wget -r -np -k

The above command will download all the files it can find in that web directory, i.e. (html files) This can be helpful if your trying to move a simple HTML site.

The -r option means recursive, the -k option converts the links to local links after it downloads the page.

HTML redirect to website

Change “” to the website you would like to redirect to. Put the code in a index.html or index.php file. If you stick it in the root website directory it’ll redirect automatically get called when you hit the website.

<meta HTTP-EQUIV="REFRESH" content=0"; url=">

Check Access Logs for website

Typically on a cPanel host your access logs are kept in


Where username is your cPanel username and is your website.

To view the logs you can use tail -f to follow the log.

tail -f /usr/local/apache/domlogs/username/

You can also use grep to search the logs.

grep "text to search" /usr/local/apache/domlogs/username/

Reset WordPress admin password in MySQL

Log into MySQL from command line

mysql -u root -p

Select the correct database

USE wordpress_db;

Print current users

SELECT * FROM wp_users;

Should get something similar to the following

mysql> SELECT * FROM wp_users
-> ;
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
| 1 | admin | 5f4dcc3b5aa765d61d8327deb882cf99 | admin | | | 2018-08-09 10:10:42 | | 0 | admin |
| 2 | bob | 210805fb52a13251f4bedc7e725e575a | bob | | | 2019-11-01 11:31:23 | | 0 | bob smith |
3 rows in set (0.00 sec)

To update the password use

UPDATE wp_users SET user_pass = MD5('NewPass') WHERE ID=1;

The MD5 hashes the NewPass and adds it to the database. You can print the users again to verify the hash changed.

You should now be able to login using the new password you configure.

How to install WordPress via ssh

Quick look at the commands.  Skip below to view the explanation of the commands

cd ~/
tar zxvf latest.tar.gz
vi wordpress/wp-config.php   <-- Edit MySQL settings
mv -R wordpress/ /var/www/html/
steve@localhost ~: chrome


SSH into your webserver


Download the latest version of WordPress

cd ~/ && wget

Extract the WordPress archive

tar zxvf latest.tar.gz

Create MySQL database and user

Refer to here if you want to do it from the command line.  The recommended way is through your web control panel i.e. cPanel, Plesk, EHCP etc.

Edit wp-config.php

Enter in the DB information.

vi wordpress/wp-config.php

Move WordPress files to web directory

mv -R wordpress/* /path/to/webdir

If you want to install WordPress inside a sub directory on your website i.e. instead of going to “” to access your WordPress site, you go to “”, then create a sub directory in your root web directory and move the WordPress files there.

Open up a browser and go to your website ( to finish the WordPress installation.


How to Restore a WordPress Site from a Backup

You need to

  1. Upload WordPress Backup Files to server
  2. Restore WordPress Backup
  3. Restore Database Backup

If you need to backup your site then you can use this how to here

1. Upload WordPress Backup Files to server

Use your favorite ftp client(FileZilla?) to upload the MySQL database and WordPress files to the server.  If they are already there skip to step 2.

In Linux you can use the ftp or sftp command.

sftp me@myserverip

once you connected you can upload your backups using put.

put wp-backup.tgz


put wp-database.sql.gz


2. Restore the WordPress Files

This is super easy because all you have to do is untar the files.  Make sure the file is in the directory that you want WordPress in.

tar -zxvf wp-backup.tgz

3. Restore Database Backup

If your MySQL backup is zipped, unzip it.

gunzip wp-database.sql.gz

We need to create a database to import our backup.  You can change wp_database to what ever you want.

mysql -u username -p

mysql> CREATE DATABASE wp_database;

Import database

mysql -u username -p wp_database < wp-database.sql


You should now have a fully functioning WordPress site.


How to Backup a WordPress Site from the Command Line

There are 2 things we need to do when we backup a WordPress site.

  1. Backup the WordPress files
  2. Backup The WordPress database

Backup the WordPress files

We can backup the files with tar by running the following command.  Replace (/Path/to/wpdir) with the actual path.

#  tar -zcvf wp-backup.tgz /Path/to/wpdir/

This can take awhile depending on how big your site is.

Backup the Database

The following command will backup the WordPress database into a gziped sql file.

mysqldump -u username -p[root_password] database_name > wp-database.sql && gzip wp-database.sql

You can find the MySQL Database, username, and password in the wp-config.php file in the wordpress directory

You should now have two files, wp-backup.tgz and wp-database.sql.qz, you’ll need both of these to restore the backup.