Profile
Achievement
 
    
                klovera's Recent Snippets
- All /
 « Prev 1 Next »
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.
        
        
        
            0 
        
        
            1738 
        
                    posted 13 years ago by klovera
            Shows the load of the cpu graphically in ssh (note you must install htop first)
        
        
        
            0 
        
        
            1289 
        
                    posted 13 years ago by klovera
            How to run a tar archive backup excluding a directory. For example, running a website root directory backup excluding the 'backups' directory.
        
        
        
            1 
        
        
            1322 
        
                    posted 13 years ago by klovera
            A simple but useful command. List processes running on the system.
        
        
        
            0 
        
        
            970 
        
                    posted 14 years ago by klovera
            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 c...
        
        
        
            0 
        
        
            1091 
        
                    posted 14 years ago by klovera
            -l switch output only the names of files in which the text occurs as opposed to each line containing the text<br>
-i switch ignores the case<br>
-r descends into subdirectories<br>
Example:
grep -lir "my search string" /home/account_name/public...
        
        
        
            0 
        
        
            1144 
        
                    posted 14 years ago by klovera
            // example <br>
$from = '2011-1-6'; <br>
$to = '2011-1-8'; <br>
dateDiff($from,$to); // returns 2
        
        
        
            1 
        
        
            1434 
        
                    posted 14 years ago by klovera