sed -i ’s/abc/xyz/g’ *.php This command is used for mass replacemet using regular expression. In the above command “abc” is replace with “xyz” from all the files extension “php”. find /var/www/html/sch_admin/ -mtime -1 This command is used to list all the files within the specified folder,say “var/www/html/sch_admin/”, which have been created or modified within the period specified,say “-1″ which [...]
select video_file from videos INTO OUTFILE ‘/tmp/video1.txt’; Query Above exports all the rows for coulmn video_file into a text file “/tmp/video1.txt” .
The evacuation of the 75 families who used to stay in the building was done in time otherwise there would have been many casualties. The five storied Reay building opposite the Dockyard railway station in Mumbai was more than 100 years old and notice had already been given for its evacuation. Residents picking their belongings from the debris
In HTTP/0.9 and 1.0, the connection is closed after a single request/response pair. In HTTP/1.1 a keep-alive-mechanism was introduced, where a connection could be reused for more than one request. Such persistent connections reduce lag perceptibly, because the client does not need to re-negotiate the TCP connection after the first request has been sent. Version 1.1 of [...]
#!/bin/bash cd /ct20/uploads/backup/ NOW=$(date +”%m-%d-%Y”) tar -cjf backupsite_$NOW.bz2 /opt/www/ct20 tar -cjf backupcms_$NOW.bz2 /opt/www/cms tar -cjf mysqlbackup_$NOW.bz2 /opt/lib/mysql
DB_LIST=”$(mysql -u root -Bse ’show databases’ | egrep -v ‘information_schema|mysql|test’)” for db in ${DB_LIST[@]} do TABLENAMES=”$(mysql -u root $db -Bse ’show tables’)” echo “Database: “$db for TABLENAME in ${TABLENAMES[@]} do mysql -u root $db -Bse “optimize TABLE $TABLENAME;” echo $TABLENAME” table has been optimized” done echo $db – $TABLENAME “Optimized has been completed” done echo “All Databases have been successfully Optimized”
DB_LIST=”$(mysql -u root -Bse ’show databases’ | egrep -v ‘information_schema|mysql|test’)” for db in ${DB_LIST[@]} do TABLENAMES=”$(mysql -u root $db -Bse ’show tables’)” echo “Database: “$db for TABLENAME in ${TABLENAMES[@]} do mysql -u root $db -Bse “Analyze TABLE $TABLENAME;” echo $TABLENAME “Analyze has been done” done echo $db – $TABLENAME “Analyzis has been completed” done echo “All Databases have been successfully Optimized”
$aDir = glob(”/clt20/uploads/videos/*.flv”); The glob() function searches for all the pathnames matching pattern according to the rules used by the libc glob() function, which is similar to the rules used by common shells.
cd /var/log/httpd NOW=$(date +”%m-%d-%Y”) mv mobile-error_log mobile-error_log-$NOW mv mobile-access_log mobile-access_log-$NOW /etc/init.d/httpd graceful sleep 5 tar -cvjf /opt/logbackup/logs-$NOW.bz2 mobile-error_log-$NOW mobile-access_log-$NOW scp mobile-access_log-$NOW domU-12-31-39-07-75-63:/clt20/uploads/mobilelog/ rm -f mobile-error_log-$NOW mobile-access_log-$NOW Remember we have exchanged the authentication key between the two servers.
Following command is used for remote syncing of a folder on two remote servers: /usr/local/bin/rsync -avz -e ssh /opt/www/cms/imagedata/2009/oct/ webdoc@domU-12-31-39-03-09-20:/opt/www/clt20/imagedata/2009/oct/ To rsync a particular file use: /usr/local/bin/rsync -avz -e ssh /opt/www/clt20/rss.xml webdoc@domU-12-31-39-03-09-20:/opt/www/clt20/