Web Developer Note

mysqldump - h ... - u ... - p ... - n - d - t --routines --triggers --all-databases > MySQLStoredProc.sql - n , --no-create-db Suppress the CREATE DATABASE ... IF EXISTS statement that normally is output for each dumped database if --all-databases or --databases is given. - d , --no-data No row information. --triggers Dump triggers for each dumped table. ( Defaults to on ; use --skip-triggers to disable.) - R , --routines Dump stored routines (functions and procedures).

select current_date() + interval 1 day; select curdate() + interval 1 day; select now() + interval 1 day;

filename=result-`date "+%T_%d-%m-%y"`.txt "; php script.php > `echo $filename`

#!/bin/bash cd /root/folder mysqldump -h 123.123.123.123 -u root -pPassword project | gzip --best > project.sql.gz dow="$(date +'%w')-$(date +'%a')" sshpass -p 'password' rsync /root/folder/* username@backup.domain.com:${dow}/backup/

https://coveloping.com/tools/hash-generator

sync; echo 3 | sudo tee /proc/sys/vm/drop_caches

[branch "master"]     remote = origin     merge = refs/heads/master     rebase = true

@hosts('123.123.123.123') def staging():     """Deploy to staging"""     env.user = 'root'     env.remote_path = '/var/www/domain'     local('git push ssh://%(user)s@%(host_string)s/%(remote_path)s master' % env)     with cd('%(remote_path)s/' % env):         run('git reset --hard')         run('./symfony doctrine:build --all-classes --no-confirmation --quiet --env=staging')         run('./symfony doctrine:migrate --env=staging')         run('lessc /var/www/domain/css/style.less /var/www/domain/css/style.css')         run('./symfony cc --quiet --env=staging') @hosts('123.123.123.124') def web():     """Pull, build classes, symlink assets on web"""     with cd('%(remote_path)s/' % env):     ...

// all url rewrite ^ https://www.domain.com$request_uri? permanent; // specific url location = /dir/file.html  { rewrite ^ "https://www.domain.com/newdir/newfile.html" permanent; }

https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql