Web page Loading

In an extremely rough and simplified sketch, assuming the simplest possible HTTP request

1. browser checks cache; if requested object is in cache and is fresh, skip to #9
2. browser asks OS for server's IP address
3. OS makes a DNS lookup and replies the IP address to the browser
4. browser opens a TCP connection to server (this step is much more complex with HTTPS)
5. browser sends the HTTP request through TCP connection
6. browser receives HTTP response and may close the TCP connection, or reuse it for another request
7. browser checks if the response is a redirect (3xx result status codes), authorization request (401), error (4xx and 5xx), etc.; these are handled differently from normal responses (2xx)
8. if cacheable, response is stored in cache
9. browser decodes response (e.g. if it's gzipped)
10. browser determines what to do with response (e.g. is it a HTML page, is it an image, is it a sound clip?)
11. browser renders response, or offers a download dialog for unrecognized types

Relocate to new path in svn

 switched to a branch


svn switch http://server/new-branch
svn switch --relocate http://server/old-path http://server/new-path

Shell script to backup all of your SVN repositories

It does very basic backup job. 

Script Config Variables

    svnrepos - absolute path of SVN repository root (where all the svn repos are created)
    bakdest - absolute path of directory where you would like to save all SVN dumps
    baktousb - absolute path of additional folder path to copy SVN dump (could be connected USB drive)


Source Code for SVN Backup Shell Script

#!/bin/sh
################################################
#
# Backup SVN repos to local folder
#
# @author   Hossain Khan
# @email    contact [at] hossainkhan [dot] info
# @version  v0.01
# @reldate  2010-03-27
################################################
#  Copyright (c) 2010 Hossain Khan
#
# Permission is hereby granted, free of charge, to any person
# obtaining a copy of this software and associated documentation
# files (the "Software"), to deal in the Software without
# restriction, including without limitation the rights to use,
# copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the
# Software is furnished to do so, subject to the following
# conditions:
#
# The above copyright notice and this permission notice shall be
# included in all copies or substantial portions of the Software.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES
# OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
# NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
# HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
# WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
# FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.
# ----------------------- END OF LICENSE TEXT ----------------------

# Record todays date
# --------------------
bakdate=$(date +%Y%m%d%H%M)
echo "--------------------------------"
echo "Running SVN backup $bakdate"
echo "--------------------------------\n"

# From where to backup repos?
# ---------------------------
svnrepos="/srv/svnrepos"
echo "\nGoing to backup all SVN repos located at: $svnrepos \n"

# Where to save the dump?
# ------------------------
bakdest="/home/username/SVN-BACKUPS"

# Location for USB drive? (to copy backup)
# ----------------------------------------
baktousb="/media/USB/Extra-BACKUP"

# _________NO-COFIG-REQUIRED-BELOW-THIS-LINE___________

# First go to SVN repo folder
cd $svnrepos


# Just make sure we have write access to backup-folder
if [ -d "$bakdest" ] && [ -w "$bakdest" ] ; then
  # Now $repo has folder names = project names
  for repo in *; do
    # do svn dump for each project
    echo "Taking backup/svndump for: $repo"
    echo "Executing : svnadmin dump $repo > $bakdest/$repo-$bakdate.svn.dump \n"
    # Now finally execute the backup
    svnadmin dump $repo > $bakdest/$repo-$bakdate.svn.dump
    # You can go an extra mile by applying tar-gz compression to svn-dumps

    # We also would like to save the dump to remote place/usb
    if [ -d "$baktousb" ] && [ -w "$baktousb" ] ; then
      # USB/other directory exists, copy the dump there
      echo "Going to copy $repo dump to $baktousb directory...\n"
      cp $bakdest/$repo-$bakdate.svn.dump $baktousb
    fi
  done
else
  echo "Unable to continue SVN backup process."
  echo "$bakdest is *NOT* a directory or you do not have write permission."
fi


# End of backup script
echo "\n\n================================="
echo " - Backup Complete, THANK YOU :-]"

» Don't forget to update script config paths at the top
» Please do not add trailing forward slash (/) with the folder paths
» Make sure the script is executable. eg. chmod 755 svnbackup-scriptname.sh


Setting Cron Job for Automated Backup
Before you setup cron job for this script, it is recommended to run this script manually from terminal to verify if it works.
If you are experienced user, then you can setup cron using crontab using terminal. Add the following to run backup daily at midnight.

# m h dom mon dow   command
# @daily = Run once a day, "0 0 * * *"
@daily bash /path/to/svnbackup-cron.sh

Import records from another table and another database

How to insert records from one table to another table in a single query

insert into first_tablename select * from second_table_name

create table and import records from another database

CREATE TABLE recipes_new LIKE production.recipes; INSERT recipes_new SELECT * FROM production.recipes;

Insert table records from another database

INSERT dbname.table_name SELECT * FROM dbname1.tablename1

Jquery Counter

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <title>
            Counter
        </title>
        <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js"></script>
        <script type="text/javascript">
            //<![CDATA[
                function createCounter(elementId,start,end,totalTime,callback)
                {
                    var jTarget=jQuery("#"+elementId);
                    var interval=totalTime/(end-start);
                    var intervalId;
                    var current=start;
                    var f=function(){
                        jTarget.text(current);
                        if(current==end)
                        {
                            clearInterval(intervalId);
                            if(callback)
                            {
                                callback();
                            }
                        }
                        ++current;
                    }
                    intervalId=setInterval(f,interval);
                    f();
                }
                jQuery(document).ready(function(){
                    createCounter("counterTarget",0,20,5000,function(){
                        alert("finished")
                    })
                })
            //]]>
        </script>
    </head>
    <body>
        <div id="counterTarget"></div>
    </body>
</html>