Ankush Grover wrote: > I want a script which automatically takes backup of the mysql > database.I have one database "dental" and I want to setup a cron job > for the database backup . Hi Ankush, You may want to take a look at an article I wrote a while back called "Backing up your MySQL data". It's available at: http://www.linuxwiz.net/wordpress/2005/01/05/backing-up-your-mysql-data/ HTH, -j -- Jeremy L. Gaddis <jeremy@xxxxxxxxxxxx> "If it's not on fire, it's a software problem."