Archive for the Category »Cron jobs issue «

Cron to unzip the .zip file?

By Gunjan · November 13, 2009

You can set the cron to unzip the .zip file. Following will be your cron setting

For example
* * * * *  server path of unzip (usr/bin/unzip)  /home/username/public_hrml/ path of the file.

You can check the path fir zip by using following command

root@gunjan[]#which zip
/usr/bin/zip

Category: Cron jobs issue  Tags: , ,  Comments off

Backup of mysql database using cron job.

By Gunjan · October 6, 2009

To generate the backup of mysql database using cron job refer following three format as per your requirement.

1) Cron job to generate  database backup in  .sql format

* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of database database.sql

2) Cronjob to compress database backup in .bz2 format

* * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of database database.bz2

3)  Cronjob to compress database backup in .gz format

* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of databasedatabase.gz

If you have any problem or idea about this thread than contact me at nsk.gunjan@gmail.com

Category: Basic Linux, Cron jobs issue, Mysql + phpmyadmin  Tags: , , , , ,  One Comment