Add an existing user to a group in Debian
sudo usermod -aG examplegroup exampleusername
Rename a Gcloud instance
gcloud beta compute instances set-name oldname --new-name=newname
Colour Palette
Install php7.4 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 https://raw.githubusercontent.com/creationix/nvm/master/install.sh | bash
source ~/.profile
nvm install 16.13.0
Magento 1 SQL db import
💡
Table storage engine for 'catalog_product_relation' doesn't have this option
Replace: ROW_FORMAT=FIXED
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
Git
💡
Connection to github.com closed by remote host.
fatal: The remote end hung up unexpectedly
fatal: The remote end hung up unexpectedly
git config --global http.postBuffer 157286400
Filesystem
Copy a folder excluding a subdirectory
rsync -av --progress sourcefolder /destinationfolder --exclude thefoldertoexclude