Download: cpanel_dbbackup_v20111029
Source: http://www.hostliketoast.com/developer-channel/

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/

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

php /home/USERACCOUNT/public_html/shell/indexer.php reindexall

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.

If you can’t edit a certain file and give you an error message, you will need to change the owner for that file or folder.
How?