Category: WordPress

This process requires a remote webhost running on a Linux distribution such as Ubuntu. Before you begin you’ll need the following information about your server.

mysql username, password and database table name

Log into your website via SSH

ssh root@your-domain.com
root@your-domian.com's password:

Open a new terminal window and run the ssh command above.

Server Side Backup storage

Once logged in navigate to a new “Current Directory” to a backup folder of your choosing and create a folder to store your backup. I like to use today’s date.

All commands below are performed with superuser / root access

cd /var/www/backups
mkdir 20221001
cd 20221001

• cd will change you to the new “current directory”
• mkdir will create a new directory

mysqldump --add-drop-table -h localhost -u username -p wp_wordpress > wordpress.bak.sql
Enter password:

• the mysqldump command above will export your database into wordpress.bak.sql

ls
wordpress.bak.sql

• ls will display your exported database file

tar czvf wordpress.tar.gz wordpress.bak.sql ../../html/wp-content/ ../../html/wp-config.php ../../html/.htaccess

• tar is a fun throwback from the days of “tape archives.”

Effectively happening is the creation of an archive file named named wordpress.tar.gz which includes the database, wp-config.php, .htaccess and everything in the wp-content folder. You may include others if you like.

cp wordpress.tar.gz /var/www/html/

Move the archive to a public folder and download.

Download to your computer

wget your-domain.com/wordpress.tar.gz

On your local machine open an new terminal window and use wget to download the archive.

Remove the original backup from the server

Be careful using the rm command. Any files removed can’t be recovered. The -i flag will require a yes or no confirmation.

rm -i /var/www/html/wordpress.tar.gz 
rm: remove regular file '/var/www/html/wordpress.tar.gz'? 

That’s it, admittedly the process takes a little practice. However, for small to medium sized sites a person could run thorough the process in a matter of minutes.

Presentation begins today at 3 PM PT

Download sample plugins referenced during the presentation.

<?php
/**
 * Plugin Name: Portfolio Custom Post Type
 * Description: A custom post type for an additional portfolio blog
 * Author: Joseph Dickson
 * Author URI: https://joseph-dickson.com
 * Version: 1.0
 * License: GPL2
 */

// Prevent direct access to this file
if ( ! defined( 'ABSPATH' ) ) exit;

// defined( 'ABSPATH' ) or die( 'No script kiddies please!' );

/**
 * Create a custom post type  
 * https://codex.wordpress.org/Function_Reference/register_post_type#Arguments
 */
function jd_portfolio_custom_post_type() {

$labels = array(
	'name'			=> 'Portfolio',
	'singular_name'		=> 'Portfolio',
	'menu_name'		=> 'Portfolio',
	'name_admin_bar'	=> 'Portfolio',
	'add_new'		=> 'Add a Portfolio Post',
	'add_new_item' 		=> 'Portfolio Post',
	'new_item'		=> 'Portfolio Post',
	'edit_item'		=> 'Edit Portfolio Post',
	'view_item'		=> 'View Portfolio Post',
	'all_items'		=> 'All Portfolio Posts',
	'search_items' 		=> 'Search Portfolio Posts',
	'parent_item_colon'	=> 'Parent Portfolio Posts:',
	'not_found'		=> 'No Portfolio Posts found.',
	'not_found_in_trash' 	=> 'No Portfolio Posts found in Trash.',
);

$args = array(
	'labels'	     	=> $labels,
	'public'		=> true,
	'publicly_queryable'	=> true,
	'show_ui'		=> true,
	'show_in_menu'		=> true,
	'menu_icon'		=> 'dashicons-format-gallery',
	'query_var'		=> true,
	'rewrite'		=> array( 'slug' => 'portfolio' ),
	'capability_type'	=> 'post',
	'has_archive'		=> true,
	'hierarchical'		=> false,
	'menu_position'		=> 21,
	'show_in_rest'		=> true,
	'supports'		=> array( 'title', 'editor', 'thumbnail' ),
);

register_post_type( 'portfolio', $args );
}

add_action( 'init', 'jd_portfolio_custom_post_type' );

// Flush rewrite rules when plugin is activated
function jd_portfolio_rewrite_flush() {
	jd_portfolio_custom_post_type();
	flush_rewrite_rules();
}
register_activation_hook( __FILE__, 'jd_rewrite_flush' );

<?php
/**
 * Plugin Name: Services Custom Post Type
 * Description: A custom post type Services Pages 
 * Version: 1.0
 * License: GPL2
 */

// Prevent direct access to this file
if ( ! defined( 'ABSPATH' ) ) exit;

/**
 * Create a custom post type  
 * https://codex.wordpress.org/Function_Reference/register_post_type#Arguments
 */
function jd_services_custom_post_type() {

$labels = array(
	'name'			=> 'Services',
	'singular_name'		=> 'Services',
	'menu_name'		=> 'Services',
	'name_admin_bar'	=> 'Services',
	'add_new'		=> 'Add a Services Page',
	'add_new_item'		=> 'Services Page',
	'new_item'		=> 'Services Page',
	'edit_item'		=> 'Edit Services Page',
	'view_item'		=> 'View Services Page',
	'all_items'		=> 'All Services Pages',
	'search_items'		=> 'Search Services Pages',
	'parent_item_colon'	=> 'Parent Services Pages:',
	'not_found'		=> 'No Services Pages found.',
	'not_found_in_trash'	=> 'No Services Pages found in Trash.',
);

$args = array(
	'labels'		=> $labels,
	'public'		=> true,
	'publicly_queryable'	=> true,
	'show_ui'		=> true,
	'show_in_menu'		=> true,
	'menu_icon'		=> 'dashicons-media-document',
	'query_var'		=> true,
	'rewrite'		=> array( 'slug' => 'services' ),
	'capability_type'	=> 'page',
	'has_archive'		=> false,
	'hierarchical'		=> true,
	'menu_position'		=> 22,
	'show_in_rest'		=> true,
	'supports'		=> array( 'title', 'editor', 'thumbnail' ),
);

register_post_type( 'services', $args );
}

add_action( 'init', 'jd_services_custom_post_type' );

// Flush rewrite rules when plugin is activated
function jd_services_rewrite_flush() {
	jd_services_custom_post_type();
	flush_rewrite_rules();
}
register_activation_hook( __FILE__, 'jd_rewrite_flush' );