cnippetz

CMD

Zip & Tar

tar -czvf /path/to/backups/archive.tar.gz /path/to/archive --exclude=*.log
tar xfvz *.tar.gz

Mac OS remove @ right's

xattr -cr ${FOLDER}

Search Files

find /home -name *PATTERN*

Search in Files

find /home -type f -name *.txt | xargs grep "keyword"
grep -rnw '/path/to/somewhere/' -e 'pattern'

Remove SVN files recursive

find . -type d -name .svn -print0 | xargs -0 rm -rf

Find and sort Files in past 1 hour

find . -type f -mmin +60  -exec ls -1rtls "{}" +

Find and delete in past 1 hour

find . -type f -mmin +60  -exec rm -rf {} \

truncate log file to last 1000 lines

tail -n 1000 file.log > tmp.log && rm file.log && mv tmp.log file.log && chown www-data:www-data file.log

truncate log file to last 1000 lines without delete original

tail -n 1000 access.log > access.tmp && echo "" > access.log && cat access.tmp > access.log && rm access.tmp

truncate log file(s) in folder

find . -type f -name "*.log" | xargs truncate -s 0

sendmail test

echo -e "Subject: Test" | /usr/bin/sendmail -v [email protected]

check user permission on folder

sudo -u www-data stat /path/to/folder/

Add a new user to the www-data group

sudo useradd -g www-data myuser
### set the password for myuser ###
sudo passwd myuser

Add a existing user to www-data group

sudo usermod -a -G www-data  myuser
id myuser
groups myuser

www-data supplementary groups membership

sudo groupadd myuser
sudo useradd -g vivek -G www-data,ftp myuser
sudo passwd myuser

Swap File

swapon -s

dd if=/dev/zero of=/swapfile1 bs=1024 count=524288
chown root:root /swapfile1
chmod 0600 /swapfile1
mkswap /swapfile1
swapon /swapfile1
echo "/swapfile1 none swap sw 0 0" >> /etc/fstab

free -m

Rename recursive File Extensions

find . -name '*.jade' | xargs rename 's/\.jade$/.pug/'

Get listen port info

macOSX: lsof -iTCP:$PORT
linux:  netstat -tulpn | grep LISTEN

Set Folder 755 + Files 644

chmod -R u+rwX,go+rX,go-w /path/to/dir

or

find /desired_location -type d -print0 | xargs -0 chmod 0755
find /desired_location -type f -print0 | xargs -0 chmod 0644

or

find /var/www/location -type d -exec chmod 755 {} \;
find /var/www/location -type f -exec chmod 644 {} \;

reset crlf to lf on OS x

find ./ -not \( -name .git -prune \) -type f -exec perl -pi -e 's/\r\n|\n|\r/\n/g' {} \;

Count writen code lines

find -E . -regex '.*\.(js|jsx|gql|scss|less)' | xargs wc -l | sort -r

GIT

Add submodule and checkout tag

git submodule add git//project.git new/path
git commit -m"new submodule"
git push

# go in submodule if you want checkout specific tag or branch of submodule
cd new/path
# check your tags
git tag -l
git checkout $tag
git commit -m'new tag'
# go back to project root
cd ..
# update submodule to new tag
git submodule update --merge --rebase

Remove Submodule

submodulePath="vendor/example"
git config -f .git/config --remove-section "submodule.${submodulePath}"
git config -f .gitmodules --remove-section "submodule.${submodulePath}"
git rm --cached "${submodulePath}"
rm -rf "${submodulePath}"
rm -rf ".git/modules/${submodulePath}"
git add .gitmodules
git commit -m "Removed ${submodulePath}"

Remove Files from repo

git rm -rf --ignore-unmatch --cached $FILE

Docker

Remove all images and containers

# Kill all container
docker kill $(docker ps -q)
# Delete all containers
docker rm $(docker ps -a -q)
# Delete all images
docker rmi $(docker images -q)
# Backup image
docker save mage/name | gzip -c > image.tgz
# Delete all stopped containers
docker rm $(docker ps -q -f status=exited)
# Delete all dangling (unused) images
docker rmi $(docker images -q -f dangling=true)
# get ssh connection to docker
docker exec -it ${DOCKER_ID} bash
# delete all
docker system prune -a

MySql

Backup All Structur+Data Databases

# mysqldump -u$USER -h$SERVER --password=$PASSWORD --opt --all-databases > backup.sql

Backup All Structur Databases

# mysqldump -d -u$USER -h$SERVER --password=$PASSWORD --opt --all-databases > backup.sql

Backup Table Structur+Data from Database

# mysqldump -u$USER -h$SERVER --password=$PASSWORD --opt --databases $SHEMA --tables $TABLE > table.sql

Backup Table Structur from Database

# mysqldump -d -u$USER -h$SERVER --password=$PASSWORD --opt --databases $SHEMA --tables $TABLE > table.sql

Import MySql Dump

# mysql -u$USER -p$PASSWORD -h$SERVER $shema < backup.sql

Change Root Password

# mysqladmin -u$USER password NEWPASSWORD
#or
$mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root';

Get Table sizes

SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) as size 
FROM information_schema.TABLES 
WHERE table_schema = "${DBNAME}" 
ORDER BY size DESC;

Enable/Disable Foreign Key Checks

# disable foreign key checks
SET FOREIGN_KEY_CHECKS = 0;

#enable the foreign key checks
SET FOREIGN_KEY_CHECKS = 1;

Get Random Rows

SELECT t.* FROM table as t,
(SELECT ROUND((SELECT MAX(id) FROM table) *rand()) as rnd FROM test LIMIT 100) tmp
WHERE t.id in (rnd)

Profiling

SET profiling=1;
SELECT * FROM table;
SHOW profiles;
SHOW profile for query ?;
SHOW profile cpu for query ?;
SET profiling=0;

Query optimizing

EXPLAIN EXTENDED SELECT * FROM table WHERE id = 12345
SHOW WARNINGS;

Reset root user

cat > restore_root_privileges.sql

update mysql.user set Super_priv='y' where user='root';
update mysql.user set Select_priv='y' where user='root';
update mysql.user set Insert_priv='y' where user='root';
update mysql.user set Update_priv='y' where user='root';
update mysql.user set Delete_priv='y' where user='root';
update mysql.user set Create_priv='y' where user='root';
update mysql.user set Drop_priv='y' where user='root';
update mysql.user set Reload_priv='y' where user='root';
update mysql.user set Shutdown_priv='y' where user='root';
update mysql.user set Process_priv='y' where user='root';
update mysql.user set File_priv='y' where user='root';
update mysql.user set Grant_priv='y' where user='root';
update mysql.user set References_priv='y' where user='root';
update mysql.user set Index_priv='y' where user='root';
update mysql.user set Alter_priv='y' where user='root';
update mysql.user set Show_db_priv='y' where user='root';
update mysql.user set Super_priv='y' where user='root';
update mysql.user set Create_tmp_table_priv='y' where user='root';
update mysql.user set Lock_tables_priv='y' where user='root';
update mysql.user set Execute_priv='y' where user='root';
update mysql.user set Repl_slave_priv='y' where user='root';
update mysql.user set Repl_client_priv='y' where user='root';
update mysql.user set Create_view_priv='y' where user='root';
update mysql.user set Show_view_priv='y' where user='root';
update mysql.user set Create_routine_priv='y' where user='root';
update mysql.user set Alter_routine_priv='y' where user='root';
update mysql.user set Create_user_priv='y' where user='root';

/etc/init.d/mysqld stop

/etc/init.d/mysqld startsos

# OR

mysqld_safe --skip-grant-tables &

mysql -vv < restore_root_privileges.sql
/etc/init.d/mysql restart
mysql -u root -p

FLUSH PRIVILEGES

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit;

Get Table ForeignKey Dependency

SELECT
  TABLE_NAME,
  COLUMN_NAME,
  CONSTRAINT_NAME,
  REFERENCED_TABLE_NAME,
  REFERENCED_COLUMN_NAME
 FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
 WHERE
  REFERENCED_TABLE_NAME = "my_table";

Apache

Permalinks mod_rewrite

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteCond %{REQUEST_FILENAME} -s [OR]
  RewriteCond %{REQUEST_FILENAME} -l [OR]
  RewriteCond %{REQUEST_FILENAME} -d
  RewriteRule ^.*$ - [NC,L]
  RewriteRule ^.*$ index.php [NC,Lo]
</IfModule>

Https mod_rewrite

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteCond %{HTTPS} !=on
  RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
</IfModule>

WWW mod_rewrite ###ect

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC]
  RewriteRule ^(.*)$ https://%1$1 [R=301,L]
</IfModule>

Nginx

Enable Multisite Sub directory language in Wordpress

server {
    listen 80;
    server_name domain.dev;
    
    access_log {PATH_LOG_FILE}/domain.dev_access.log;
    error_log {PATH_LOG_FILE}/domain.dev_error.log error;

    root   {DOC_PATH}/;
    index  index.php index.html;

    if (!-e $request_filename) {
        rewrite /wp-admin$ $scheme://$host$uri/ permanent;
        rewrite ^(/[^/]+)?(/wp-.*) $2 last;
        rewrite ^/[^/]+(/.*.php)$ $1 last;
    }

    location / {
        try_files $uri $uri/ /index.php$is_args$args;
    }

    location ~ ^\/(en)(\/?.*)$ {
        try_files $2 $2/ /index.php$is_args$args;
    }

    location ~ \.php$ {
        fastcgi_pass   127.0.0.1:9000;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include        fastcgi_params;
    }
}

NodeJS User and NVM

useradd -s /bin/bash -m -g www-data nodejs
su nodejs
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.35.0/install.sh | bash

Install Nginx + letsencrypt + brotli

add-apt-repository universe
add-apt-repository ppa:certbot/certbot

wget https://nginx.org/keys/nginx_signing.key
sudo apt-key add nginx_signing.key
rm nginx_signing.key
printf "deb https://nginx.org/packages/mainline/ubuntu/ `lsb_release -sc` nginx \ndeb-src https://nginx.org/packages/mainline/ubuntu/ `lsb_release -sc` nginx \n" >> /etc/apt/sources.list.d/nginx_mainline.list
apt-get update
apt install -y nginx nginx-module-geoip certbot python-certbot-nginx build-essential software-properties-common libpcre3 libpcre3-dev zlib1g zlib1g-dev openssl libssl-dev
certbot --nginx

printf "\nload_module modules/ngx_http_geoip_module.so;\nload_module modules/ngx_stream_geoip_module.so;\n$(cat /etc/nginx/nginx.conf)" > /etc/nginx/nginx.conf
nginx -v
systemctl enable nginx.service
wget https://nginx.org/download/nginx-1.17.5.tar.gz && tar zxvf nginx-1.17.5.tar.gz
rm nginx-1.17.5.tar.gz

git clone https://github.com/eustas/ngx_brotli.git
cd ngx_brotli && git submodule update --init && cd ~

cd nginx-1.17.5/
./configure --with-compat --add-dynamic-module=../ngx_brotli
make modules
sudo cp objs/*.so /etc/nginx/modules
ll /usr/lib/nginx/modules
chmod 644 /usr/lib/nginx/modules/*.so
printf "\nload_module modules/ngx_http_brotli_filter_module.so;\nload_module modules/ngx_http_brotli_static_module.so;\n$(cat /etc/nginx/nginx.conf)" > /etc/nginx/nginx.conf
rm nginx-1.17.5 ngx_brotli -r

add-apt-repository universe

create wildcard cert with letsencrypt

# certbot certonly --manual --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory -d "*.<your-domain>" -d <your-domain>

Name		Name	Last commit message	Last commit date
Latest commit History 43 Commits
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
my.html		my.html

License

xelaz/cnippetz

Folders and files

Latest commit

History

Repository files navigation

cnippetz

CMD

Zip & Tar

Mac OS remove @ right's

Search Files

Search in Files

Remove SVN files recursive

Find and sort Files in past 1 hour

Find and delete in past 1 hour

truncate log file to last 1000 lines

truncate log file to last 1000 lines without delete original

truncate log file(s) in folder

sendmail test

check user permission on folder

Add a new user to the www-data group

Add a existing user to www-data group

www-data supplementary groups membership

Swap File

Rename recursive File Extensions

Get listen port info

Set Folder 755 + Files 644

reset crlf to lf on OS x

Count writen code lines

GIT

Add submodule and checkout tag

Remove Submodule

Remove Files from repo

Docker

Remove all images and containers

MySql

Backup All Structur+Data Databases

Backup All Structur Databases

Backup Table Structur+Data from Database

Backup Table Structur from Database

Import MySql Dump

Change Root Password

Get Table sizes

Enable/Disable Foreign Key Checks

Get Random Rows

Profiling

Query optimizing

Reset root user

FLUSH PRIVILEGES

Get Table ForeignKey Dependency

Apache

Permalinks mod_rewrite

Https mod_rewrite

WWW mod_rewrite ###ect

Nginx

Enable Multisite Sub directory language in Wordpress

NodeJS User and NVM

Install Nginx + letsencrypt + brotli

create wildcard cert with letsencrypt

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages