By marcom on Saturday, October 15, 2022
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:
By marcom on Thursday, April 16, 2020
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)
By marcom on Monday, February 22, 2021
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.
By marcom on Thursday, November 11, 2021
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.
By marcom on Wednesday, April 28, 2021
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.
By marcom on Friday, May 14, 2021
Prerequisite
- A Solr server running either on your local environment or on another server
Create a new Solr server
- Open your browser and login to your Drupal site
- Go to Configuration -> Search and metadata -> Search API
- Click the Add server button
- In the Add search server page, enter the following information
- Server name: Solr
- Backend: Solr
- Solr Connector: Standard
- Solr host: staging.upanupstudios.co
By marcom on Friday, May 14, 2021
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.
By marcom on Tuesday, April 7, 2020
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.
By marcom on Tuesday, January 12, 2021
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
By marcom on Saturday, October 10, 2020
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.
By marcom on Wednesday, November 4, 2020
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.