Help and tutorials https://www.xmind.net/m/WwtB/ Where is program located which composer tzt ### nano - nano line nubers Ctrl + C - nano goto last line Ctrl + V - nano goto line nr 42 Alt + G Markdown PHP reader installed with composer https://github.com/hollodotme/TreeMDown https://packagist.org/packages/hollodotme/treemdown https://semaphoreci.com/community/tutorials/getting-started-with-composer-for-php-dependency-management ----new 2024 # Linux terminal commands # Navigation and Commands History ## Keyboard shortcuts, shortcut keys Keyboard shortcuts that can drastically speed up your command line usage. - Alt+Backspace: Deletes the previous word. - Ctrl+A: Moves the cursor to the start of line. - Ctrl+E: Moves the cursor to the end of line. - Ctrl+L: Clear Screen (same as "clear") - CTRL+D: quits the shell. - Ctrl+Z: Puts suspended process background. fg restores it. - Tab: Auto-complete files and folder names ## Autojump Autojump is a faster way to navigate your filesystem. It works by maintaining a database of the directories you use the most from the command line. Autojump: a cd command that learns. ``` sh apt install autojump # add the following line to your ~/.bashrc # . /usr/share/autojump/autojump.sh # Usage j "dirspec" j --stat ``` ## Reverse search ^R, Ctrl+R - ^R reverse search. Hit ^R, type a fragment of a previous command you want to match, and hit ^R until you find the one you want. Then Idon't have to remember recently used commands that are still in my history. - CTRL-R and type a few first letters of *iptables', like*ipt\\'. That will display the last iptables command you executed. ## History Top 10 commands used: ``` sh history | awk 'BEGIN {FS="[ \t]+|\\|"} {print $3}' | sort | uniq -c | sort -nr | head # Execute previous command history !43 history \| grep nologin ``` Bash history: "ignoredups" and "erasedups" setting conflict with common history across sessions http://unix.stackexchange.com/questions/18212/bash-history-ignoredups-and-erasedups-setting-conflict-with-common-history ## Change Directory, CD cd - It's the command-line equivalent of the back button, it takes you to the previous directory you were in. It's worth mentioning that 'cd' takes you to your home directory as does 'cd\~'. # Search, find, locate, count To find files and directories your are looking for. ## Find from everywhere # search for a string in all files # recursive, line number, match the whole word grep -rnw '/path/to/somewhere/' -e "pattern" # only search through those files which have .c or .h extensions: grep --include=\*.{c,h} -rnw '/path/to/somewhere/' -e "pattern" # exclude searching all the files ending with .o extension: grep --exclude=\*.o -rnw '/path/to/somewhere/' -e "pattern" # recursive, ignore case, show the file name, not the result itself, starting at the root grep -ril "pattern" / ## Find ``` sh find . -name "my.txt" #find all files named "my.txt" find . -type d -name "mydir" #find all directories named "mydir" find . -type f -name "..jpg" #find all ".jpg" files find . -type f -size +100M #find all files larger than 100MB find . -type f -size +100M -size -500M #find files with a specific size range find . -type f -mtime -1 #find all files modified in last 24 hours find . -mtime -7 -mtime +1 #find files modified bets yesterday & a week ago find . -type f -name "*.tmp" -delete #find and remove all ".tmp" files find . -type f -perm 0777 #find all files with "777" permission find . -type f -perm -u+x find all files executable by the user find . -type f -name "*.txt" -exec cat {} \; #find and cat all "*.txt" files find . -type f -amin -60 #find all files accessed within the last hour find . -type f -user dan #find all files owned by the user "dan" find . -type f -ctime -2 #find files created within last 2 days find . -maxdepth 1 -name "my.txt" #search only in current dir find . -type f -name "*.txt" I xargs chmod 644 #chmod all ".txt" to 644 find . -type f -name "*.jpg" I xargs tar -cf img.tgz #archive all ".jpg" files find . -type f -name "*.png" I xargs -I {} mv {} #gulp move all ".png" files find . -type f -name "*.txt" I xargs prep "Hello" #search for Hello in ".txt" find . -xtypel-delete #find and remove all broken symbolic links find . -type d -empty -delete #find and remove all empty directories find . -newermt "2024-01-01" ! -newermt "2024-03-15" #use a time range find . -name '*.gz' # find extensions find -iname inc_func.php # Search from file find . -name '*.txt' -print | xargs perl -pi -'s/Windows/Linux/ig' *.txt #Replace the text in all text files in current dir and down find /root/ -name \*.mp3 -print # Find and make playlist ``` ## Find big files du -a /home | sort -n -r | head -n 5 #find biggest files and directories du -a /var | sort -n -r | head -n 10 #top 10 largest file / directories: ls -lSrh #find the biggest files in the current directory du -kx | egrep -v "\./.+/" | sort –n # largest directories ## find a pattern in files grep -rnw '/path/to/somewhere/' -e 'pattern' ## find a pattern in files and rename them needed: "mv ./report-GHBAG-1B ./report-stream-agg-1B" find . -name '*-GHBAG-*' -exec bash -c 'mv $0 ${0/GHBAG/stream-agg}' {} \; rename 's/GHBAG/stream-agg/' *-GHBAG-* you could in effect search recursively down directories rename 's/magic.ee/hero.ee/' **/*magic.ee* rename 's/magic.ee/hero.ee/' *magic.ee* ## Find and replace text within a file using sed command # one file sed -i 's/old-text/new-text/g' input.txt # multiple files find ./ -type f -exec sed -i 's/string1/string2/g' {} \; #Find and replace text within a file using sed command The example below uses grep to recursively find files grep -rli 'old-word' * | xargs -i@ sed -i 's/old-word/new-word/g'@ grep -rli 'magic.ee' * | xargs -i@ sed -i 's/magic.ee/hero.ee/g' @ ## Find Replace same text in multiple files If you have text you want to replace in multiple locations perl -i -pe \s/Windows/Linux/;\ test* ## Count Number of Files and Subdirectories tree -iLf 1 ## Count all the lines of code in a directory recursively https://stackoverflow.com/questions/1358540/how-to-count-all-the-lines-of-code-in-a-directory-recursively ## List all files modified in last 5 minutes excluding .svn directories find . -type d -name .svn -prune -o -mmin -5 -type f -print ## Locate If you want to search a file on your system through the command line, and speed is the topmost priority use locate. locate To update search index database use update # Rename ### Renaming/moving files with suffixes quickly ``` sh cp /home/foo/realllylongname.cpp{,-old\} # This expands to: cp /home/foo/realllylongname.cpp /home/foo/realllylongname.cpp-old # Just to point out that to do the reverse (going from .cpp-old to .cpp) you\\d do cp /home/foo/realllylongname.cpp{-old,\} ``` ### Rename many files at once $ ls this_has_text_to_find_1.txt this_has_text_to_find_2.txt this_has_text_to_find_3.txt $ rename \s/text_to_find/been_renamed/\ *.txt $ ls this_has_been_renamed_1.txt this_has_been_renamed_2.txt this_has_been_renamed_3.txt # Copy using tar, keep rights, from Windows to Linux ## network copy with ssh and tar you can use ssh in conjunction with tar to pull an entire directory tree from a remote machine into your current directory: ssh tar cf - -C \ . \| tar xvf - For example, let\\s say you have a "bsmith" account on a host called "apple". You want to copy those files into your "bobsmith" account on a host called "pear". You\\d log into your "bobsmith@pear" account and type the following: ssh bsmith@apple tar cf - -C /home/bsmith . \| tar xvf - This technique is useful when you have insufficient disk space on the source machine to make an intermediate tarball. ## Tar pipe copy One of my favorites tricks with bash is the "tar pipe". When you have a monstrous quantity of files to copy from one directory to another, doing cp * /an/other/dir doesn't work if the number of files is too high and explode the bash globber, so, the tar pipe : (cd /path/to/source/dir/ ; tar cf - * ) | (cd /path/to/destination/ ; tar xf - ) ## Copy and keep permissions cp -rp /home/my_home /media/backup/my_home ## Copy from Windows to Linux and vice versa set PATH="C:\Program Files (x86)\PuTTY" pscp ISPConfig-3.0.5.4p9.tar.gz root@vps.magic.ee:/root/ # copy other way around set PATH="C:\Program Files (x86)\PuTTY" pscp -v root@192.168.100.110:/var/games/minecraft/servers/Paradise.tar.gz c:/lan # File manipulation ## Eliminate duplicate lines from a file sort -u filename > filename.new ## Execute command but without SOME files Use \* without foo or bar: rm !(foo|bar) $ ls foo bar foobar FOO $ echo !(foo\|bar) foobar FOO ## Cycles, loop ```sh echo "I can count to a thousand" ...{000..999\} for f in *.txt; do mv $f ${f/txt/doc\}; done touch {1,2\}.txt ``` ## Repeate Repeats your last command. !! Most useful in the form: sudo !! ## Make or remove directory, folder (mkdir) Make a whole directory tree with one command Use the -p option to mkdir and make all parent directories along with their children in a single command. mkdir -p tmp/a/b/c Delete folder rmdir foldername ## Rename and/or resize images Fond of your new camera but cannot put up with the terrible names? Do you want also to prepare them for publishing on the web? No problem, a simple bash script is what you need. Utility convert comes from Imagemagick bundle. ```sh #!/bin/sh counter=1 root=mypict resolution=400x300 for i in ls -1 $1/*.jpg; do echo "Now working on $i" convert -resize $resolution $i ${root}_${counter}.jpg counter=expr $counter + 1 done ``` Save the script in a file called picturename.sh and make it executable with chmod u+x picturename.sh and store it somewhere in your path. Now, if you have a bunch of .jpg files in the directory /path/to/pictdir, all you have to do is to execute picturename.sh /path/to/pictdir and in the current directory you'll find mypict_1.jpg, mypict_2.jpg etc, which are the resized versions of your original ones. You can change the script according to your needs, or, if you're just looking for super-simple image resizing, try looking at the mogrify command with its -geometry parameter. ## Tar Backup tar -cjf bk-etc-date +%Y-%m-%d.tar.bz2 /location/ # Listing – ls How to list only subdirectories in the current one. ls -d */ Listing today's files only ls -al --time-style=+%D \| grep date +%D # Machine information, hardware ```sh uname -a cat /etc/issue.net cat /etc/readhat-release # Login banner (Message of the Day) cat /etc/motd ``` ## Becoming human Pass the -h or -H (and other options) command line option to GNU or BSD utilities to get output of command commands like ls, df, du, in human-understandable formats: ls -lh # print sizes in human readable format (e.g., 1K 234M 2G) df -h df -k # show output in bytes, KB, MB, or GB free -b free -k free -m free -g # print sizes in human readable format (e.g., 1K 234M 2G) du -h # get file system perms in human readable format stat -c %A /boot # compare human readable numbers sort -h -a file # Show the size of each file but in a more human readable way tree -h tree -h /boot ## Processes, ps List the top ten time-wasters: ps aux --sort=-%cpu | grep -m 11 -v whoami ## Symlinks How to symlink a file in Linux? ln -s /var/www/clients/client1/web111/ wiki.hero.ee Edit symlink ln -sfn /etc/apache2/sites-available/hero.ee.vhost 100-hero.ee.vhost ## Hostname nano /etc/hostname The file will contain something along the lines of this: NETWORKING="yes" GATEWAY="10.0.0.1" HOSTNAME="www.example.com" ## Find IP aadress ```sh lynx -dump http://whatismyip.org curl ipinfo.io CURRENT_IP="$(curl -s checkip.dyndns.org | sed -e 's/.*Current IP Address: //' -e 's/<.*$//')" echo $CURRENT_IP # Find IP and replace in dump.sql CURRENT_IP="$(curl -s checkip.dyndns.org | sed -e 's/.*Current IP Address: //' -e 's/<.*$//')" sed -i "s/CURRENT_IP/$CURRENT_IP/g" /home/ubuntu/dump.sql #example { "ip": "213.25.102.124", "hostname": "12324.s.t123vps.eu", "city": "", "region": "", "country": "LT", "loc": "56.0000,24.0000", "org": "AS62282 UAB Rakrejus" } ``` ## Linux Version Check ### Debian version lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 8.4 (jessie) Release: 8.4 Codename: Jessie ### Other version check mysql --version Check what Debian version you are running on your Linux system cat /etc/issue cat /etc/debian_version # DHCPD vi /etc/dhcp/dhcpd.conf # Named (DNS) vi /var/named/tmk.zone # .BASHRC /root/.bashrc don't put duplicate lines in the history. HISTCONTROL=ignoredups:ignorespace Append to the history file, don't overwrite it shopt -s histappend For setting history length see HISTSIZE and HISTFILESIZE in bash(1) HISTSIZE=1000 HISTFILESIZE=2000 Enable color support of ls and also add handy aliases alias grep='grep --color=auto' alias ls='ls --color=auto' For quick commands use ls aliases alias ll='ls -alF' alias la='ls -A' alias l='ls -CF' #netinfo - shows network information for your system netinfo () { echo "--------------- Network Information ---------------" /sbin/ifconfig | awk /'inet addr/ {print $2}' /sbin/ifconfig | awk /'Bcast/ {print $3}' /sbin/ifconfig | awk /'inet addr/ {print $4}' /sbin/ifconfig | awk /'HWaddr/ {print $4,$5}' myip=lynx -dump -hiddenlinks=ignore -nolist http://checkip.dyndns.org:8245/ | sed '/^$/d; s/^[ ]*//g; s/[ ]*$//g' echo "${myip}" echo "---------------------------------------------------" } ### Functions ### function mktar() { tar czf "${1%%/}.tar.gz" "${1%%/}/"; } function rot13() { echo "$@" | tr a-zA-Z n-za-mN-ZA-M; } function getip() { lynx -dump http://whatismyip.org/ } # Usage: repeat PERIOD COMMAND function repeat() { local period period=$1; shift; while (true); do eval "$@"; sleep $period; done } #Dirsize - finds directory sizes and lists them for the current directory dirsize () { du -shx * .[a-zA-Z0-9_]* 2> /dev/null | \ egrep '^ *[0-9.]*[MG]' | sort -n > /tmp/list egrep '^ *[0-9.]*M' /tmp/list egrep '^ *[0-9.]*G' /tmp/list rm -rf /tmp/list } # Define a word - USAGE: define dog define () { lynx -dump "http://www.google.com/search?hl=en&q=define%3A+${1}&btnG=Google+Search" | grep -m 3 -w "*" | sed 's/;/ -/g' | cut -d- -f1 > /tmp/templookup.txt if [[ -s /tmp/templookup.txt ]] ;then until ! read response do echo "${response}" done < /tmp/templookup.txt else echo "Sorry $USER, I can't find the term \"${1} \"" fi \rm -f /tmp/templookup.txt } ##### Extract - extract most common compression types extract() { local e=0 i c for i; do if [[ -f $i && -r $i ]]; then c='' case $i in *.t@(gz|lz|xz|b@(2|z?(2))|a@(z|r?(.@(Z|bz?(2)|gz|lzma|xz))))) c='bsdtar xvf' ;; *.7z) c='7z x' ;; *.Z) c='uncompress' ;; *.bz2) c='bunzip2' ;; *.exe) c='cabextract' ;; *.gz) c='gunzip' ;; *.rar) c='unrar x' ;; *.xz) c='unxz' ;; *.zip) c='unzip' ;; *) echo "$0: cannot extract \$i': Unrecognized file extension" >&2; e=1 ;; esac [[ $c ]] && command $c "$i" else echo "$0: cannot extract \$i': File is unreadable" >&2; e=2 fi done return $e } clock () { while true;do clear;echo "===========";date +"%r";echo "===========";sleep 1;done } screenshot () { import -frame -strip -quality 75 "$HOME/$(date +%s).png" } ################################################## # Switch two files (comes in handy) # ################################################## function switchfile() { mv $1 ${1}.tmp && $2 $1 && mv ${1}.tmp $2 } ################################################## # Changes spaces to underscores in names # ################################################## function underscore() { for f in * ; do [ "${f}" != "${f// /_}" ] mv -- "${f}" "${f// /_}" done } clear ## Alias alias lsnew=" ls -al --time-style=+%D \| grep date +%D " alias cd..="cd .." alias ls="ls -la" alias l=\ls -la ### Creature aliases # vi /root/.bashrc alias are='service apache2 restart' alias cdsa='cd /etc/apache2/sites-available' alias cdse='cd /etc/apache2/sites-enabled' alias cdwww='cd /var/www/' # Autojump: a cd command that learns; apt install autojump . /usr/share/autojump/autojump.sh #a splash of colour in prompts: PS1="\[\033[06;32m\] \h \[\033[42;30m\] \W \[\033[00;31m\] \$ \[\e[m\]" # Bash shell scripts ### Creafind #!/bin/sh if test -z $1 then echo "Usage: creafind " echo "creafind looks searchword from files in selected directoty." echo "error: 1st file argument is missing!" echo "Insert search path. Example: /etc or /home" echo "Program by (C)reature 2004." exit 2 fi if test -z $2 then echo "error: 2nd file argument is missing!" echo "Insert search word. Example: localhost" exit 2 fi find $1 -type f -exec grep -l $2 {} \; If you only want the filenames that have a matching line without showing the matching line: find . -type f -print0 | xargs -0 grep -l "some string" # Monitor, tail, while, watch Want to get the last few lines of a log file? tail /var/log/syslog Want to quickly read over a file from the start? more /var/log/syslog Want to quickly find if a file contains some text? grep "find this text" /var/log/syslog ## While When downloading a large file I quite often do: while ls -la \\; do sleep 5; done And then just ctrl+c when I'm done ## Watch watch - execute a program periodically, showing output fullscreen watch --interval=10 lynx -dump [http://dslrouter/stats.html](http://dslrouter/stats.html) # Programs ## VI, VIM – text editor - Ctrl+G: Current line number - Shift+G: Go to end of file http://www.cyberciti.biz/faq/vim-text-editor-find-and-replace-all-text/ :%s/kass/xn--pder-0qa/g duplicate line in editor (copy one row and paste) yy p copy and paste 78 rows yy78 p delete 10 rows dd10 VI goto line nr vi +14 file.py ## GIT ### Git commands GITHUB Luua kasutaja github.com keskkonda Luua repository nimega "phpkursus2016" #GIT reposse laadimine git init git add * git status git remote add origin https://github.com/kasutajanimi/phpkursus2016.git git commit -m "minu kommentaar" git push -u origin master #uue faili üleslaadimine touch foo.php git add * git commit -m "minu teine kommentaar" git push -u origin master #kogu repo endale masinasse tõmbamine (teha üks kord) cd /var/www/html git clone https://github.com/kasutajanimi/phpkursus2016.git #tõmmatakse alla repo saab muudatused (teha iga päev) git pull 

    #Codelight ja GIT
    LAMP all saab sama teha CodeLight tekstiredaktoriga määrates esimesel korral Plugins->Git->Set GIT repository path /var/www/html
    Edaspidi klikkides parema nupuga failile ja valides alguses "+ Add file" ning hiljem
    Plugins->Git->Commit local Changes
    Plugins->Git->Push local Commits


    #how to delete all commit history in github?
    Deleting the .git folder may cause problems in your git repository. If you want to delete all your commit history but keep the code in its current state, it is very safe to do it as in the following:
     Checkout
     git checkout --orphan latest_branch

     Add all the files
     git add -A

     Commit the changes
     git commit -am "commit message"

     Delete the branch
     git branch -D master

     Rename the current branch to master
     git branch -m master

     Finally, force update your repository
     git push -f origin master

    PS: this will not keep your old commit history around

    ==Email==

    echo test | mail -s "test message" root


    ==Listen open ports==

     # Use ss to list open ports
     sudo ss -tulpn
     
     # Listening ports and applications using lsof command
     sudo lsof -i -P -n | grep LISTEN
     
     # see open ports
     netstat -lnp 
     

    ==Debug processes, ps==

    
    is php-fpm working
    sudo ps aux | grep php-fpm  | grep master

    check php fpm config being used
    sudo php-fpm7.4 -tt

    #php.ini info
    php -r \@phpinfo\(\)\; | grep 'PHP Version' -m 1
    php -r \@phpinfo\(\)\; | grep 'Loaded Configuration File' -m 1

    sudo ps aux | grep 'php'

    restart php-fpm
    sudo /etc/init.d/php7.4-fpm restart


    sudo systemctl list-unit-files | grep -E 'php[^fpm]*fpm'
    sudo systemctl is-active php7.4-fpm.service

    nginx logs
    find /etc/nginx -name '*.conf' | xargs grep -i log

## WGET

wget examples
http://www.labnol.org/software/wget-command-examples/28750/

Download an entire website including all the linked pages and files

wget --execute robots=off --recursive --no-parent --continue --no-clobber (http://example.com

## MySQL, MariaSQL

MySQL dump (find and replace some text and import back)

	mysqldump --single-transaction -u YourDBuserNameHere -p --databases mediawiki > mediawiki.sql  
	find mediawiki.sql -type f -exec sed -i 's/:\/\/magic.ee\//:\/\/hero.ee\//g' {} \;  
	mysqlimport -u YourDBuserNameHere -p mediawiki < mediawiki.sql   

import SQL dump

	mysql -uroot -proot database_name_here < /home/ubuntu/dump.sql

Create MySQL users

	CREATE USER 'username_here'@'%' IDENTIFIED BY 'password_here';  GRANT ALL PRIVILEGES ON *.* TO 'username_here'@'%' WITH GRANT OPTION;

MySQL database credentials

	sudo mysql -uroot -proot -hlocalhost -e "DROP DATABASE IF EXISTS database_name_here; CREATE DATABASE database_name_here;  CREATE USER 'username_here'@'%' IDENTIFIED BY 'Dest1nyIsAll';  GRANT ALL PRIVILEGES ON *.* TO 'username_here'@'%' WITH GRANT OPTION;  FLUSH PRIVILEGES;"

## Apache

### Find Top 10 IP Addresses Accessing Your Apache Web Server

	awk '{ print $1}' /var/log/apache2/access.log \| sort \| uniq -c \| sort -nr \| head -n 10

### Virtual host, subdomain

VIRTUAL HOST
http://kimbriggs.com/computers/computer-notes/linux-notes/apache2-public_html-virtual-directories.file

	cd /etc/apache2/sites-available/  
	cp kass.kellu.eu.conf xn--pder-0qa.kellu.eu.conf  
	a2ensite xn--pder-0qa.kellu.eu.conf  
	service apache2 restart

https://bensmann.no/restrict-sftp-users-to-home-folder/
http://askubuntu.com/questions/134425/how-can-i-chroot-sftp-only-ssh-users-into-their-homes-http://askubuntu.com/questions/134425/how-can-i-chroot-sftp-only-ssh-users-into-their-homes

### CHECK apache2 confg syntax

apachectl -t

## SSH commection

	# SSH connection with key  
	ssh -i ~/.ssh/awsmykey.pem ubuntu@24.210.84.711  
	  
	# view SSH keys allowed connect to this nod  
	sudo vi ~/.ssh/authorized_keys  
	  
	# Generating a new SSH key  
	ssh-keygen -t rsa -b 4096 -C "your_email@example.com"  
	  
	# extract SSH PUBlic key from secret key (read a private SSH key file)  
	ssh-keygen -y -f ~/.ssh/awskey3.pem >  ~/.ssh/awskey3.pub  

## Unzip, tar

	\\#Unzip to right directory tar -xzf
	SyntaxHighlight_GeSHi-REL1_27-20c4ad5.tar.gz -C
	/var/www/wiki.magic.ee/extensions

	gzip -d file.gz tar xvf file.tar
	
	Create tar Archive File  
	tar -cvf tecmint-14-09-12.tar /home/tecmint/

## PhpMyAdmin

PMA login timeout
http://stackoverflow.com/questions/13697820/phpmyadmin-logs-out-after-1440-secs

phpmyadmin logs out after 1440 secs

Settings->Features->General->Login cookie validity

## Applications



## APT

Upgrade system

apt upgrade


## VMware, Virtualbox

### VMware

Multiple TTY windows

-   Edit-Preferences->Hot Keys->Ctrl+Alt+Shift
-   In X-Windows press
-   Ctrl+Alt F1-F6
-   Ctrl+Alt F7 = X windows


## Wordpress

	# Install wordpress  
	curl -LO [https://wordpress.org/latest.tar.gz](https://wordpress.org/latest.tar.gz)  
	tar xzvf latest.tar.gz  
	cp ./wordpress/wp-config-sample.php ./wordpress/wp-config.php  
	sudo sed -i 's/password_here/InsertYourSecretPasswordHere/' ./wordpress/wp-config.php  
	rm -rf /var/www/html  
	sudo mv ./wordpress /var/www/html  
	chmod -R 0755 /var/www/html  
	chown -R www-data:www-data /var/www/html
	
	WP wp-config.php  
	install updates and plugins  
	define(\FS_METHOD\, \direct\);
	
	Wordpress change URL in database
	
	UPDATE wp_options SET option_value = replace(option_value, 'magic.ee', 'hero.ee') WHERE option_name = 'home' OR option_name = 'siteurl';  
	UPDATE wp_posts SET post_content = replace(post_content, 'magic.ee', 'hero.ee');  
	UPDATE wp_postmeta SET meta_value = replace(meta_value,'magic.ee','hero.ee');  
	UPDATE wp_usermeta SET meta_value = replace(meta_value, 'magic.ee','hero.ee');  
	UPDATE wp_links SET link_url = replace(link_url, 'magic.ee','hero.ee');  
	UPDATE wp_comments SET comment_content = replace(comment_content , 'magic.ee','hero.ee');  
	UPDATE wp_posts SET post_content = replace(post_content, 'magic.ee', 'hero.ee');  
	UPDATE wp_posts SET guid = replace(guid, 'magic.ee','hero.ee');  
	UPDATE wp_links SET link_image = replace(link_image, 'magic.ee','hero.ee');

## Putty

Putty settings to enable keypad keys
Change Settings -> Features -> Disable application keypad mode