Thursday, July 14, 2016

Sunday, July 10, 2016

VLOOKUP

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

Saturday, July 9, 2016

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.

Thursday, July 7, 2016

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

Friday, July 1, 2016

MySQL crips

Mysql



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