Snipplr

(MySQL) Replace a text in SQL Server Table Column - klovera

Sat, 31 Mar 2012 05:21:38 UTC

If you have a Table which has a Column of type char or varchar or even text, and you want to change a portion of text in it for example a path. In this case you need to change the same text with new one in every records.

(Bash) Check CentOS version from SSH - klovera

Wed, 15 Feb 2012 06:01:21 UTC

Check the version of CentOS

(Apache) Force www with htaccess - klovera

Thu, 09 Feb 2012 14:01:00 UTC

Domain ambiguous way of forcing www with htaccess

(Bash) Show load visually (apache) - klovera

Fri, 03 Feb 2012 11:59:51 UTC

Shows the load of the cpu graphically in ssh (note you must install htop first)

(Bash) List files with details - klovera

Wed, 01 Feb 2012 02:30:21 UTC

List files in varying detail

(Bash) tar excluding directory - klovera

Sat, 14 Jan 2012 04:02:34 UTC

How to run a tar archive backup excluding a directory. For example, running a website root directory backup excluding the 'backups' directory.

(Bash) Remove files by extension - klovera

Tue, 10 Jan 2012 00:22:42 UTC

browse to directory and enter

(Bash) List only directories - klovera

Wed, 02 Nov 2011 03:00:22 UTC

(PHP) PHP Function: getDirectory - klovera

Wed, 19 Oct 2011 23:16:48 UTC

Returns an array of folder names contained within the passed path.

(PHP) function: getImages($folder) - klovera

Tue, 18 Oct 2011 13:40:17 UTC

Returns all the images in a folder randomly.Listed back in this format: { src: "/'.$localdir.$file.'" },

(Bash) Restore file & folder default permissions - klovera

Tue, 18 Oct 2011 13:39:13 UTC

When modifying file permissions it is sometimes necessary to go back to the drawing board and set back to the default permissions. The following command can be used via ssh and takes a couple seconds vs trying to do this via ftp file by file (which can take a very long time depending on the size of your website). Change to the directory you want changed, then run the following. It will set permission for all files to 644 and all directories to 755. This works for pretty much any Linux server.

(Bash) Get files (wget) - klovera

Tue, 18 Oct 2011 13:31:48 UTC

Used to get file. First one is done via http. Second is done via FTP.

(Bash) Extract tar archive to specified location - klovera

Tue, 18 Oct 2011 13:29:19 UTC

(Bash) Disable IPv6 on CentOS - klovera

Tue, 18 Oct 2011 13:28:08 UTC

How to disable IPv6 on CentOS. Suggested for security if you are runing a security check on csf firewall. The above is only for witht he 5.4 update - more infor can be found here: http://wiki.centos.org/FAQ/CentOS5#head-47912ebdae3b5ac10ff76053ef057c366b421dc4

(Bash) Change File/Folder Ownership - klovera

Tue, 18 Oct 2011 13:26:36 UTC

(Bash) Bitdefender Scan - klovera

Tue, 18 Oct 2011 13:24:43 UTC

Must have bitdefender installed.

(jQuery) jQuery Zebra Stripes - klovera

Tue, 18 Oct 2011 13:22:58 UTC

Place inside document ready.

(jQuery) jQuery Document Ready "OnReady!" - klovera

Tue, 18 Oct 2011 13:20:50 UTC

(jQuery) Basic live 'click' event - klovera

Tue, 18 Oct 2011 13:18:53 UTC

(jQuery) Basic 'click' event - klovera

Tue, 18 Oct 2011 13:17:44 UTC

(Bash) Recursively copy a directory for backup - klovera

Wed, 21 Sep 2011 23:43:13 UTC

Kudos to http://snipplr.com/view/26670/

(Bash) View 'top' processes - klovera

Tue, 06 Sep 2011 02:25:30 UTC

A simple but useful command. List processes running on the system.

(Bash) Current Exim Mail Queue - klovera

Mon, 05 Sep 2011 03:20:25 UTC

Displays the # of emails in Exim queue.

(Bash) Changing back to default permissions - klovera

Wed, 31 Aug 2011 01:04:35 UTC

When modifying file permissions it is sometimes necessary to go back to the drawing board and set back to the default permissions. The following command can be used via ssh and takes a couple seconds vs trying to do this via ftp file by file (which can take a very long time depending on the size of your website). Change to the directory you want changed, then run these. Will set permission for all files to 644 and all directories to 755.

(Bash) Bash remove non-empty directory - klovera

Fri, 26 Aug 2011 22:54:08 UTC

(Bash) Change file ownership - klovera

Fri, 26 Aug 2011 22:34:30 UTC

-R = recursive

(Bash) Find files by file name - klovera

Thu, 25 Aug 2011 02:25:28 UTC

Search for files by file name

(Bash) Find files containing search string - klovera

Sat, 13 Aug 2011 05:41:04 UTC

-l switch output only the names of files in which the text occurs as opposed to each line containing the text
-i switch ignores the case
-r descends into subdirectories
Example: grep -lir "my search string" /home/account_name/public_html/

(Bash) Get Active Processes - klovera

Fri, 04 Feb 2011 08:10:48 UTC

List current processes

(Bash) Number of Connections by IP - klovera

Fri, 28 Jan 2011 04:11:33 UTC

Returns a list of the number of connections by IP.

(PHP) Number of days between 2 dates - klovera

Fri, 21 Jan 2011 08:11:23 UTC

// example
$from = '2011-1-6';
$to = '2011-1-8';
dateDiff($from,$to); // returns 2