Useful Commands

Useful Commands

Colour Palette

System Admin

Rename a Gcloud instance

gcloud beta compute instances set-name oldname --new-name=newname

Install PHP on Debian

sudo apt install php7.4-{fpm,sqlite,curl,bcmath,bz2,dom,intl,gd,mbstring,mysql,zip}

Install nvm and node.js on Debian

curl | bash
source ~/.profile 
nvm install 16.13.0

Git problems with large files

git config --global http.postBuffer 157286400
Connection to closed by remote host.
fatal: The remote end hung up unexpectedly

Copy a folder excluding a subdirectory

rsync -av --progress sourcefolder /destinationfolder --exclude thefoldertoexclude

Add colours to the root bash terminal

PS1='${debian_chroot:+($debian_chroot)}\[\033[01;31m\]\u@\h\[\033[00m\]:\[\033[01;34m\]\w\[\033[00m\]\$ '

Add to the bottom of root's .bashrc to get have a red prompt.

Magento 1 SQL db import

Table storage engine for 'catalog_product_relation' doesn't have this option


cat magento-db-dump.sql | grep '=FIXED'
sed -ie 's/ROW_FORMAT=FIXED//g' magento-db-dump.sql

Find MySQL / MariaDB my.cnf file

mysql --help | grep /my.cnf | xargs ls