Thanks to antville.org
Extract words

Extract all incorrect words in first.txt file and all correct ones in second.txt file using the following sed command.

sed -n 's/.*"\([^"]*\)".*/\1/p' DocumentList.xml > first.txt

sed -n 's/[^"]*"[^\"]*"[^\"]*"\([^\"]*\)".*/\1/p' DocumentList.xml > second.txt

... Link (0 comments) ... Comment


Why do I care for Linux?

I don't care that much for other software. Linux is more than a kernel or an operating system. It is a symbol money does not rule everything. You don't pay for Linux. You don't have to watch ads when using it. In return, please be a little more friendly and tolerant to the people who build it. While Linux is built by professionals today, there is more heart and soul poured into it than in other operating systems.

http://beza1e1.tuxen.de/my_linux_history.html

... Link (0 comments) ... Comment


backup mysql users 

3 steps to install percona utility...

yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL

wget percona.com/get/pt-show-grants 

perl pt-show-grants -h 1.2.3.4 -uroot -pPasswd

... Link (0 comments) ... Comment


clear tmp folder

Here is following commands to clear unwanted stuff from the /tmp partition on the server?

tmpwatch –mtime –all 48 /tmp

The above command will remove all files and folders from the /tmp which have not been accessed in the last couple of days (24×2=48). You can modify the number of hours as required.

... Link (0 comments) ... Comment


change your server time to IST

If you need to change your server clock to another timezone for e.g. (Indian Standard Time), you can do so by modifying the /etc/localtime file:

mv /etc/localtime /etc/localtime.bak

ln -s /usr/share/zoneinfo/Asia/Calcutta /etc/localtime

... Link (0 comments) ... Comment


Transfer root emails to another email address

If you have root access to the server then open the file /etc/aliases in your favorite editor. Look for the section Person who should get root mail and make the change as required.

vim /etc/aliases

Person who should get root’s mail  ##
root:   info@unixserveradmin.com

... Link (0 comments) ... Comment


special strings in cron

Instead of the first five fields, you can use any one of eight special strings. It will not just save your time but it will improve readability.

Special string    Meaning
@reboot ——> Run once, at startup.
@yearly ——> Run once a year, “0 0 1 1 *”.
@annually –> (same as @yearly)
@monthly —> Run once a month, “0 0 1 * *”.
@weekly —–> Run once a week, “0 0 * * 0″.
@daily ——–> Run once a day, “0 0 * * *”.
@midnight –> (same as @daily)
@hourly —–> Run once an hour, “0 * * * *”.

For e.g. run ntpdate every hour:
@hourly /path/to/ntpdatevim /etc/ssh/sshd_config

... Link (0 comments) ... Comment


while loop

This is a sample shell script while loop

while read mydb
do
echo "time scp /home/backup/mysql/$mydb/ticket.txt.gz 1.2.3.4:/tmp/$mydb.txt.gz "
done << dblist
akolaII
akol
ako
dblist

... Link (0 comments) ... Comment


Selecting from error log

grep "error" error_log |awk -F[ {'print $4'} \
| sort | sed -e 's/]//g' | grep -v "/var/www/html/" \
| grep -v "/usr/local/src/code" | awk {'print $2'} \
| grep -v "75.142.246.205" |uniq | awk -F. {'print $1"."$2"."$3"/24"'} |uniq

114.80.93/24
119.63.193/24
124.115.0/24
205.234.253/24

... Link (0 comments) ... Comment


mysql and shell command

date -d"-1 day ago" +'%b%d'

equals to

mysql -Bse"select date_format(date(date_add(now() , interval 1 day)),'%b%d')"

... Link (0 comments) ... Comment


Online for 8125 days
Last modified: 10/13/24, 10:18 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
October
Recent updates
Extract words Extract all incorrect
words in first.txt file and all correct ones in second.txt...
by shantanuo (10/13/24, 10:18 AM)
Remove hyperlink in LO writer
1) Select "Internet Link" from Character styles. 2) Right click...
by shantanuo (10/9/24, 8:09 AM)
Templates in LO writer 1)
File > Templates > Save as Template 2) Give it...
by shantanuo (10/9/24, 8:07 AM)
discretize continuous features You can
"discretize" or "bin" continuous features into categorical features. from sklearn.preprocessing...
by shantanuo (4/24/24, 9:33 AM)
User Defined Property You
can create User Defined Property in libreoffice writer. File – Properties...
by shantanuo (1/9/23, 8:52 AM)
Arranging Chapters in the Navigator
To use a custom paragraph style for a heading, choose...
by shantanuo (1/4/23, 8:26 AM)
Use focus mode using Android
phones Settings > Digital Wellbeing and parental controls. Tap your...
by shantanuo (1/1/23, 3:59 AM)
Embed Fonts in document If
you use a font that the recipient is unlike to...
by shantanuo (12/18/22, 10:07 AM)
Using Navigator in Writer To
open the Navigator, select View > Navigator, or press the...
by shantanuo (12/18/22, 10:06 AM)
More about hyphenation The settings
for Tools > Options > Language Settings > Writing Aids...
by shantanuo (12/18/22, 10:04 AM)
link or unlink template If
you are using Libre office then template changer extension is...
by shantanuo (12/16/22, 5:27 AM)
Finding Styles you can select
Edit > Find and Replace > Other Options > Paragraph...
by shantanuo (12/14/22, 7:17 AM)
regex in clac In LibreOffice
Calc, you can use function REGEX for e.g. Begins with...
by shantanuo (12/14/22, 4:40 AM)
Libre Calc tips Turn Off
Grid Lines If you want to turn off grid lines...
by shantanuo (12/13/22, 8:14 AM)
More about Styles You can
goto View - Styles and change "All Styles" to "Applied...
by shantanuo (12/13/22, 7:49 AM)
Page Break Before Every Chapter
If your chapter titles are using the "Heading 2" Style:...
by shantanuo (12/13/22, 6:36 AM)
View and print in different
color Displaying Color in LO but Printing as White Page...
by shantanuo (12/13/22, 6:26 AM)
Change Normal Template in Libreoffice
Writer 1) Open a new file and set your font;...
by shantanuo (12/12/22, 8:45 AM)
Short english words in Devanagari
The list of short english words written in Devanagari. #...
by shantanuo (10/5/22, 9:05 AM)
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)

RSS feed

Made with Antville
Helma Object Publisher