LPodolski

find ./src -type f  -size -100000c  | sim_text -pit 75

Take note! Above similarity comparison is limited to 100k bytes in command above. This is due to performance restrictions. If you include some big text files in similarity comparison it would take very long time. So you need to exclude those files.

You can also reduce similar files search to specific file type for example:

find ./src -type f -name '*.php'  | sim_text -pit 75

this would limit similarity search only to *.php files

to install sim_text command:

sudo apt install similarity-tester

alias gb='git branch XXX---$(git rev-parse --abbrev-ref HEAD)---$(date +%Y-%m-%d_%H-%M-%S)'

and add it to

gedit ~/.bash_aliases

To get absolute datetime when system started you can use following command:

last reboot | head -1

In ubuntu to turn off and on monitor using command:

xrandr --output DP1 --off

To turn it on again, left of HDMI monitor you can use:

xrandr --output DP1 --left-of HDMI1 --auto

To list monitors, to see their names ie HDM1, DP1 etc:

 xrandr -q

find . -type f | shuf -n 1 | xargs -d "\n" xdg-open

Opens random file in current directory with default program, it traverses directories recursively

mogrify -resize 50% *.jpg

install by:

sudo apt-get install imagemagick

Simple query to get count of all tables in database, as real data:

SET @tableSchema = 'my_schema';
SET SESSION group_concat_max_len = 10000000;
SET @rowCounts = (
  SELECT group_concat(CONCAT('SELECT ''',TABLE_NAME,''', COUNT(*) FROM ', TABLE_NAME) SEPARATOR ' union all ')
  FROM information_schema.tables WHERE table_schema = @tableSchema
);
PREPARE statement FROM @rowCounts;
EXECUTE statement;

-- don't run dealloc until you've exported your results ;)
DEALLOCATE PREPARE statement;

It is also possible to use:

SELECT 
    TABLE_NAME, 
    TABLE_ROWS 
FROM 
    `information_schema`.`tables` 
WHERE 
    `table_schema` = 'YOUR_DB_NAME';

but it gives only estimates

ng() { gnome-terminal -x sh -c "$*; bash"; }

shortcut for .bashrc

Usage:

ng cat /etc/hosts

https://www.linuxbabe.com/linux-server/install-apache-mariadb-and-php7-lamp-stack-on-ubuntu-16-04-lts

https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-on-ubuntu-16-04-lamp/

https://httpd.apache.org/docs/current/vhosts/examples.html

apt-get install php-redis

apt-get install php-xdebug

php7.0-curl

sudo apt install php7.0-sqlite3

sudo apt-get install php7.0-soap

sudo apt install nautilus-admin

sudo apt-get install openssl

sudo apt-get install oracle-java8-installer

sudo apt install percona-toolkit

sudo apt-get install percona-server-server-5.7

sudo pear install PHP_CodeSniffer

sudo pear install PHP_CodeSniffer

sudo apt install phpcs

https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html

https://ubuntuforums.org/showthread.php?t=2275033

http://unix.stackexchange.com/questions/85973/how-to-edit-var-www-files-using-phpstorm

https://ubuntuforums.org/showthread.php?t=2275033

http://tomaszdziurko.pl/2015/11/1-and-the-only-one-to-customize-intellij-idea-memory-settings/

http://symfony.com/doc/current/setup.html

https://getcomposer.org/doc/00-intro.md#globally