Yum

yum clean all
yum makecache fast

Windows 7 update stuck - fix for Windows Update Client

Microsoft released a new Windows Update Client Update to fix the slow update searching/installation problem:

64bit only, download, stop the windows update service and install
1 https://www.microsoft.com/en-us/download/details.aspx?id=49540
2 https://www.microsoft.com/en-us/download/details.aspx?id=53332
Note: Requires installed Service Pack 1 and also this patch
https://www.microsoft.com/en-us/download/details.aspx?id=46817

If the problem persists :
Alternative 1:
Bunch of updates from microsoft update page
http://catalog.update.microsoft.com/v7/site/search.aspx?q=kb3125574

Alternative 2:
Windows offline updater:
http://www.wsusoffline.net/

Alternative 3:

An user discovered an strange "solution". The speedup can be improved if you install the Security Update for Windows Kernel-Mode Drivers (win32k.sys) if such an update is released at the current patchday.

For June 2016, the win32k.sys update is KB3161664.

Source:

http://superuser.com/questions/951960/windows-7-sp1-windows-update-stuck-checking-for-updates

How to export PUTTY Sessions list?

You can export it simply by:

regedit /e "%userprofile%\Desktop\putty-sessions.reg" HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\Sessions

Or, for exporting all settings:

regedit /e "%userprofile%\Desktop\putty.reg" HKEY_CURRENT_USER\Software\SimonTatham

iftop utf-8 bug

export NCURSES_NO_UTF8_ACS=1 && iftop $@

Public IP from CLI

wget -qO- http://ipecho.net/plain ; echo

VLOOKUP

Функция подбора значения из одной таблицы в другую по ID:
таблица 1 : таблица в которую ищем данные из таблицы 2
lookup_value: ячейка ID в таблице 1
table_array: вся таблица 2
col_index_num: номер столбца с нужными данными из таблицы 2
range_lookup: 0 - точное соответствие

Remote Restarting a Domain PC

Introduce

If you're like me and have a couple of troublesome PCs on your network that need a quick "kick" every once in a while, here's a couple of quick ways to remote reboot them.

NOTE: You must have administrative access over the remote system.

There are 2 ways to do this:
1) Quick command line.
2) Small Batch script.

sendmail doesn't send emails to own domains

If domain is my-domain.com, in /etc/postfix/main.cf, change:

mydestination = my-domain.com, localhost, localhost.localdomain
instead of
mydestination = localhost, localhost.localdomain, localhost

service postfix restart

MySQL crips

BackUp's
New Databases
OverAll
Data Handling

Archive: tar / tar.gz / bz2

How to create .tar.gz

• tar -cvf file.tar /full/path - creates tar
• tar -czvf file.tar.gz /full/path - creates .tar.gz (архив)
• tar -cjvf file.tar.bz2 /full/path - creates .tar.bz2 (архив)

How to extract (dearchive) .tar

• for extract tar.gz file: tar -xvf file.tar.gz