Cron Job: Delete Files & Directories Older Than x Days or Minutes on Linux

Nov 17, 2011 | Server Management | 0 comments

The find utility on linux allows you to pass in a bunch of interesting arguments, including one to execute another command on each file. We’ll use this in order to figure out what files are older than a certain number of days, and then use the rm command to delete them.

find /path/to/files* -mtime +5 -exec rm {} \;

EX.

find /home/ACCOUNT-USER/public_html/test-delete/* -mtime +1 -exec rm {} \;

Note that there are spaces between rm, {}, and \;

Explanation

* The first argument is the path to the files. This can be a path, a directory, or a wildcard as in the example above. I would recommend using the full path, and make sure that you run the command without the exec rm to make sure you are getting the right results.
* The second argument, -mtime, is used to specify the number of days old that the file is. If you enter +5, it will find files older than 5 days.
* The third argument, -exec, allows you to pass in a command such as rm. The {} \; at the end is required to end the command.

This should work on Ubuntu, Suse, Redhat, or pretty much any version of linux.

In order to force delete the dirs, you need to do ‘rm -fr’ instead of just ‘rm’. -f will force deletion and -r will do it recursively on all subdirs.

find can accept a -type argument where ‘find -type f’ will only find files, ‘find -type d’ will find dirs, and ‘find -type l’ will find links.

find /home/ACCOUNT-USER/public_html/test-delete/* -mmin +1 -exec rm {} \;

Source:
http://www.howtogeek.com/howto/ubuntu/delete-files-older-than-x-days-on-linux/

Cron Job: to backup database

Nov 16, 2011 | Server Management | 0 comments

DATE=`date +\%d-\%m-\%y-\%H:\%m:\%S`; /usr/bin/mysqldump -h localhost -u USERNAME -pPASSWORD DATABASENAME | gzip > /home/ACCOUNT-USER/mysql_backups/DATABASENAME-${DATE}.sql.gz

Where
USERNAME -> Database username
PASSWORD -> Database password
DATABASENAME -> Database name

Note:
Don’t remove “-p” let say that your database name is “mydatabase” and password is “1234abcd” and username is “myname”. It will be like that:

DATE=`date +\%d-\%m-\%y-\%H:\%m:\%S`; /usr/bin/mysqldump -h localhost -u myname -p1234abcd mydatabse | gzip > /home/ACCOUNT-USER/mysql_backups/mydatabse-${DATE}.sql.gz

Convert mysql Database to utf8

Oct 10, 2010 | Server Management | 0 comments

If you want to convert a database to UTF8 you can use this script
Phoca Changing Collation Tool

Download link
http://www.phoca.cz/download/category/17-phoca-changing-collation-tool

VIN: any arabic data will be lose.