Freeing up storage space is a constant battle whether it is on your local computer or on your servers. To list directories and their file sizes, and then sorting them from the largest to smallest, makes life easier by using the following command:

du -sh -- */ | sort -rh

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:

TL;DR:

1. If your SSL private key is encrypted, you'll see "ENCRYPTED" in the file.

2. To use the key, you must decrypt it using OpenSSL with the passphrase.

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.

Rsync (remote sync) is a linux utility to synchronize local and remote files and directories, mainly used in terminal.

I use this mainly in downloading/uploading files and directories from and to remote servers or even local files. I use rsync as well with shell scripts for backups that are ran automatically daily using the crontab utility.

The Sequel Pro app only allows a single .sql or a compressed .sql.gz file to be imported, but what if you have hundreds of .sql files to import from your Drupal or WordPress backup?

The solution is to combine the .sql file into one using the cat command.