SQL files can be huge in sizes to load onto an editor in order to fix queries that is preventing it to be imported properly. Instead of loading onto an editor, you can simply execute a find a replace using the find app.

find . -type f -name database.sql -exec sed -i '' s/[text-to-find]/[text-to-replace]/g {} +

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

You can check the version of SSH (Secure Shell) on an Ubuntu server by running the following command in the terminal:

$ ssh -V

This will display the version of the SSH client installed on your system. If you want to check the version of the SSH server, you can connect to the server using SSH and run the same command.

Alternatively, you can check the version of the OpenSSH package installed on your Ubuntu server by running the following command:

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.

File and folder permissions can be a problem sometimes and can cause errors when not set properly on your server.

For WordPress installations, you can set the proper permissions with the following commands:

Set all directory permissions:

find . -type d -exec chmod 755 {} \;

Set all file permissions:

find . -type f -exec chmod 644 {} \;