HowTo Empty Directory
To delete all files from /tmp/bar/ directory (including all files from subdirectories such as /tmp/bar/dir1), enter: $ cd /tmp/bar/ $ find . -type f -delete
Synchronizing folders with rsync
Update the contents of a folder In order to save bandwidth and time, we can avoid copying the files that we already have in the destination folder that have not been modified in the source folder. To do this, we can add the parameter -u to rsync, this will synchronize the destination folder with the source folder, this…
Adding a Private Key to Your Mac OSX Keychain
On Mac OSX, the native SSH client can use the built-in keychain directly. To add your private key to the keychain simply use the command: ssh-add -K /path/of/private/key As an example if your private key is stored at ~/.ssh and is named id_rsa, you would use the command: ssh-add -K ~/.ssh/id_rsa You will then be…
How to change the max file upload size for phpMyAdmin in Plesk
Here it is for others who wish to increase the upload limit from 2M to whatever you desire: Change the following file: /usr/local/psa/admin/conf/php.ini And the following value: “upload_max_filesize” & “post_max_size” From “2147483647″ to “100M” (100M or whatever value you wish to set the cap to) You will then need to run the following commands to…
Merge directories in Mac OS X
You can quickly merge any two directories within Mac OS X by using the command line tool ditto. Launch the Terminal and use the following syntax: ditto directory1 directory2 If a directory already exists at the destination (directory2) then the contents of the source (directory1) will be merged with the contents of the destination (destination2).…
Find files with 777 permission
find /nas/content/live/lifeofaserver/vhosts/ -perm 777 … or to same the results in a file: find /nas/content/live/lifeofaserver/vhosts/ -perm 777 > /root/files.txt Also, if you want to only see the files with some permission you can use: find /nas/content/live/lifeofaserver/vhosts/ -perm 777 -type f …. or directories: find /nas/content/live/lifeofaserver/vhosts/ -perm 777 -type d
Possible options to exclude files/directories from backup using tar
Exclude files using multiple patterns tar -czf backup.tar.gz –exclude=PATTERN1 –exclude=PATTERN2 … /path/to/backup Exclude files using an exclude file filled with a list of patterns tar -czf backup.tar.gz -X /path/to/exclude.txt /path/to/backup Exclude files using tags by placing a tag file in any directory that should be skipped tar -czf backup.tar.gz –exclude-tag-all=exclude.tag /path/to/backup Use a wild card…
How to Disable Password Authentication for SSH
Once you have SSH Keys configured, you can add some extra security to your server by disabling password authentication for SSH. (Note that if you do lose your private key, this will make the server inaccessible and you will need to contact HostGator to have this re-enabled.) To disable this setting, you can do the…
Mass update several rows in a MySQL database
Will set all rows as enabled UPDATE Catalog SET Status=’Enabled’
How Do I Display the Contents of a Linux File?
$ cat filename The cat command (short for concatenate) shown in this example is like the DOS type command. In response to the command cat pig_info, the system simply splatters the file on the screen. If there is more data in the file than will fit on one screen, the contents whiz by before you…
Enable connecting remotely to mysql database on CentOS
Edit file: /etc/my.cnf Comment out line: skip-networking So should look like this: #skip-networking Restart MySQL /etc/init.d/mysqld restart
How to Find & Replace Data in MySQL
To find a string in a certain field and replace it with another string: update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html
Enable Apache Module mod_authz_user
This module provides authorization capabilities so that authenticated users can be allowed or denied access to portions of the web site. mod_authz_user grants access if the authenticated user is listed in a Require user directive. Alternatively Require valid-user can be used to grant access to all successfully authenticated users. Uncomment this line in /etc/httpd/conf/httpd.conf: LoadModule…
Setup Proxy on WAMP server
Edit this file C:\wamp\bin\apache\Apache2.2.11\conf\extra\httpd-vhosts.conf
To start/stop mysql server on a linux machine
To start mysql server: /etc/init.d/mysqld start To stop mysql server: /etc/init.d/mysqld stop To restart mysql server /etc/init.d/mysqld restart Source: http://theos.in/desktop-linux/tip-that-matters/how-do-i-restart-mysql-server/
Automating backups with Amazon S3 on Linux
On your server To use s3sync you need ruby to be installed. I found openssl was already installed on my server but you may need to get that too if you want to use ssl connections (you can use yum for this too). To get ruby use yum: yum install ruby Once has installed check…
Using s3cmd.rb to copy files to/from Amazon
Examples ——– List all the buckets your account owns: s3cmd.rb listbuckets Create a new bucket: s3cmd.rb createbucket BucketName Create a new bucket in the EU: s3cmd.rb createbucket BucketName EU Find out the location constraint of a bucket: s3cmd.rb location BucketName Delete an old bucket you don’t want any more: s3cmd.rb deletebucket BucketName Find out what’s…
Searching for files over 10MB in size
NOTE: To adjust the size of your search replace +10000k with the size you desired, such as the following: 50MB: +50000k 100MB: +100000k 500MB: +500000k find / -type f -size +10000k -exec ls -lh {} \; | awk ‘{ print $5 “: ” $9 }’ |sort -n
Allow external connections to MySQL server on Plesk
Comment out “skip-networking parameter” in /etc/my.cnf
Using s3sync.rb to synchronize files to/from Amazon
Examples: ——— (using S3 bucket ‘mybucket’ and prefix ‘pre’) Put the local etc directory itself into S3 s3sync.rb -r /etc mybucket:pre (This will yield S3 keys named pre/etc/…) Put the contents of the local /etc dir into S3, rename dir: s3sync.rb -r /etc/ mybucket:pre/etcbackup (This will yield S3 keys named pre/etcbackup/…) Put contents of S3…
Create .htaccess file on a WAMP System
If you are creating a new passwd file: C:\wamp\bin\apache\Apache2.2.11\bin\htpasswd.exe -c passfile username If your are editing an existing password file: C:\wamp\bin\apache\Apache2.2.11\bin\htpasswd.exe passfile username .htaccess contents: AuthType Basic require valid-user Satisfy all AuthUserFile C:/webroot/passwdfile AuthName “My Secret Folder” Move the created pass file to the desired location. and add a .htaccess file to the folder you want…
Easily find or search files or directories
To search the current directory and all subdirectories for a folder or file, use the following command: find . -name filename Source: http://www.tech-recipes.com/rx/976/unixlinux-easily-find-or-search-files-or-directories/