Re: Best script to bacup mysql database?

If you have a second computer which you can connect to you database,
consider setting up a slave database using replication.
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html has the details.

or mysqldump --opt -u user --p "password" --all-databases | bzip2 -c
> database.`date '+%d-%M-%Y'`.bz2 worked in the cron worked for me for
a long time

-- 
Raj Shekhar		           
blog : http://rajshekhar.net/blog  home : http://rajshekhar.net
Disclaimer : http://rajshekhar.net/disclaimer