Export and Import MySQL Databases in Terminal

Tobias Fischer Unsplash

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:

Configure Solr Server for Search API in Drupal 8 or 9

Sabri Tuzcu - Drink some coffee

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

Install Apache Solr on MacOS

Sunset avove Indian ocean Varkala

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.

How to Decrypt an RSA Private Key Using OpenSSL

Laptop with encryted code - Markus Spiske

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.

Setup a local web development environment with XAMPP for MacOS

XAMPP is an easy to install Apache distribution containing MariaDB, PHP and Perl.

XAMPP  is a popular open-source software stack that provides a development environment for web applications and is completely free. The XAMPP open source package has been set up to be incredibly easy to install and to use. It includes an Apache web server containing MySQL or MariaDB and PHP (including Perl), which is the stack you primarily need for web development.

Find and rename %20 from file names with a space in terminal

Find and rename %20 from file names with a space in terminal

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.

Use Virtual Camera with Webex Meetings web app in Firefox browser

Webex Meeting web app

With recent updates to Webex Meetings desktop app, using a third-party virtual camera app has been restricted. However, you are able to use the virtual camera with the Webex Meeting web app in a Firefox browser. At the time of writing, I was able to make this work using the CamTwist app, Firefox browser on my MacOS Catalina.