"Composer is a tool for dependency management in PHP. It allows you to declare the libraries your project depends on and it will manage (install/update) them for you." - getcomposer.org

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:

GnuPG is a complete and free implementation of the OpenPGP standard encryption. 

Installing GPG

GPG is available in Windows and many distributions of Linux, including a graphical user interface (GUI) that is easy to use. However, I prefer using the command line tools instead.

Red Hat / CentOS

sudo yum install gnupg

Ubuntu / Debian

sudo apt-get install gnupg

Note: Use gpg2 (version 2.x)

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.

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.

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.

When making changes in your httpd-vhost.conf file, make sure to test it before reloading the apache config file or restarting apache.

Mac OSX

apachectl configtest

XAMPP OSX

/Applications/XAMPP/xamppfiles/bin/apachectl configtest

Errors should display, if there are any, otherwise you'll see the Syntax OK to indicate that there are no errors and you can reload the apache config file or restart apache.

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).

Being part of leading team requires to motivate and inspire your colleagues in doing their work well. In our weekly meeting, I'll be tracking the quotes I've scoured the internet throughout the year.
 

If I had nine hours to chop down a tree, I’d spend the first six sharpening my axe
- Abraham Lincoln

Don't be busy, be productive

Intelligence is the ability to adapt to change
- Stephen Hawking

At times, there are differences between your local or staging and production environment in handling URL encodings. In strict environments (likely production), HTML links to files with encoded characters in their file name will result to a 403 (not found) error. Therefore, you must rename the file names in your directory.

Install rename utility

In MacOS, use homebrew to install the rename utility.

If you’re using multiple Webex accounts, you might get stuck signing-in to the same account even though you login into another when starting or joining a meeting using the Webex Meetings app. This certainly might get annoying but here is the work-around.

For MacOS (Catalina), what you have to do is clear your saved logins using the Keychain Access app.