Truncate or Empty table in mysql from phpmyadmin
Truncate or Empty table in mysql from phpmyadmin phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the Web
eduguru
My first web page – html introduction
My first web page – html introduction HTML is the standard markup language to create Web page. HTML stands for Hyper Text Markup Language HTML describes the structure of a Web page HTML consists of a series of elements HTML elements tell the browser how to display the content HTML elements are represented by tags … Read more
Convert mysql table engine to innodb
Convert mysql table engine to innodb
Linux Shell script example 1
A example in BASH is as follows to display welcome message 5 times with for loop. #!/bin/bash for i in 1 2 3 4 5 do echo “Welcome $i times” done
Linux shell script – for loop using ranges or counting
Linux shell script – for loop using ranges or counting The for loop can be set using the numerical range. The range is specified by a beginning and ending number. The for loop executes a sequence of commands for each member in a list of items. A representative example in BASH is as follows to … Read more
Shell Script Example – Linux
Shell Script Example – Linux for ((j=12;j<=31;j++)); do echo $j year=2020 month=01 day=$j mkdir /mnt/recording/final/11/$year-$month-$day results=($(mysql –user name -ppassword -h 192.168.2.4 db -Bse “SELECT id FROM calldetails WHERE calldate BETWEEN ‘$year-$month-$day 00:00:00’ AND ‘$year-$month-$day 23:00:00′”)) cnt=${#results[@]} for (( i=0 ; i<cnt ; i++ )) do a=${results[$i]} echo auid=$a; cp /home/data/$year-$month-$day/$a.gsm /mnt/recording/final/11/$year-$month-$day/$a.gsm done done
Shell Script : Nested for loop statement
Shell Script : Nested for loop statement Nested for loops means loop within loop. They are useful for when you want to repeat something serveral times for several things. For example, create a shell script called nestedforloop.sh: #!/bin/bash # A shell script to print each number five times. for (( i = 1; i <= … Read more
Rename Multiple Files In Linux using mmv command
Rename Multiple Files In Linux using mmv command mmv moves (or copies, appends, or links, as specified) each source file matching a from pattern to the target name specified by the to pattern. yum install mmv Let us say, you have the following files in your current directory. $ ls a1.txt a2.txt a3.txt Now you want … Read more
asterisk: sip remove header
asterisk: sip remove header SIPRemoveHeader() Synopsis Remove SIP headers previously added with SIPAddHeader Description SIPRemoveHeader() allows you to remove headers which were previously added with SIPAddHeader(). If no parameter is supplied, all previously added headers will be removed. If a parameter is supplied, only the matching headers will be removed. For example you have added … Read more
Asterisk:[general] section of sip.conf
Asterisk:[general] section of sip.conf SIP Configuration – general The [general] section of sip.conf includes the following variables: allowsubscribe = yes|no : Allow or Ignore Subscribe requests allow = <codec> : Allow codecs in order of preference (Use DISALLOW=ALL first, before allowing other codecs) disallow = all : Disallow all codecs (global configuration) allowexternaldomains = yes|no : Enable/Disable INVITE and … Read more