Generating an SSH key

1. Open Terminal
2. Generate your key pair using your email address

   $ ssh-keygen -t ed25519 -C "your.email@example.com"
   Generating public/private ed25519 key pair

3. When prompted to "Enter a file in which to save the key," press Enter to accept the default file location

   $ Enter file in which to save the key (~/.ssh/id_ed25519): ~/.ssh/[id_keyfile]

4. At the prompt, simply press enter for an empty passphrase

   $ Enter passphrase (empty for no passphrase): [press enter]
   $

Export database

Export your database to create a backup using the following command:

$ mysqldump --opt --hex-blob [-h host] -u [user] -p [database] > [database].sql

Compress with gzip

You can also compress your database on-the-fly with gzip:

mysqldump --opt --hex-blob [-h host] -u [user] -p [database] | gzip -c > [database].sql.gz

Show progress

To show progress, you can use pv:

Part of any website are the domains and URLs that users type in their browsers in order to reach a web page. However, it can be challenging to manage should it need to be changed. Thankfully, there are URL redirects for that.

URL redirect (forwarding) allows you to forward your domain visitors to any URL of your choice, either to a new domain or a different website altogether.

In an Apache web server, use the following rewrite rules in your .htaccess file.

Windows servers use .pfx files which contain the public key file (SSL certificate file) and the private key file. However, this can also be converted to .pem files to  be used on Linux server using OpenSSL.

Prerequisite

• A Solr server running either on your local environment or on another server

Create a new Solr server

1. Open your browser and login to your Drupal site
2. Go to Configuration -> Search and metadata -> Search API
3. Click the Add server button
4. In the Add search server page, enter the following information
   • Server name: Solr
   • Backend: Solr
   • Solr Connector: Standard
   • Solr host: staging.upanupstudios.co

Apache "Solr is the popular, blazing-fast, open source enterprise search platform built on Apache Lucene™." it is "highly reliable, scalable and fault tolerant, providing distributed indexing, replication and load-balanced querying, automated failover and recovery, centralized configuration and more. Solr powers the search and navigation features of many of the world's largest internet sites."

You can easily install Solr on your MacOS using homebrew.

There is already basic article on upgrading Drupal 8 to Drupal 9, however, there is a bit more to consider, with my current setup of Drupal using composer.

I previously wrote how to Display copyright disclaimer on your webcam using CamTwist, and here's how to do the same using the Open Broadcaster Software (OBS).

In July of 2020, GitHub announced its intent to require the use of token-based authentication for all Git operation and on August 13, 2021, the password authentication will be deprecated. With SSH keys, you can connect to GitHub, including Drupal, without supplying your username and password each time you push or pull changes to or from the repo.

Follow the steps below to connect to GitHub and Drupal with SSH keys from your local environment.

When installing a SSL certificate with a private key that is encrypted with a passphrase, you must decrypt the private key first. You can identify whether a private key is encrypted or not by opening the private key (.key or .pem file) using a text editor or command line. You should see the text ENCRYPTED if the private key is encrypted.