IT Mission Linux Tips, Hacks, Tutorials, Howtos - Itmission.org | Main / CreatingMySqlBackupUsingCron

Main.CreatingMySqlBackupUsingCron History

Hide minor edits - Show changes to output

April 24, 2009, at 02:49 PM by 118.95.5.140 -

Added lines 1-3:

(:Google1:)
(:Googletxt:)
----

July 23, 2007, at 11:42 AM by 210.18.59.46 -

Added lines 1-7:

*%blue%Backup mysql db using Cron.

date=`date -I` ; mysqldump -uusername -pthepass .all-databases | gzip >
/home/linux/mysql_$date.sql.gz

*Replace username and thepass with the correct username and the pass.
*The user need to have access to the database being taken for backup.

Restore