Cron / Sql Backup

[vlad]

Is their any way to make a cron that backs up your sql files to a different database every midnight?

[Uridium]

Im not sure but i did do a script that would backup SQLS to a folder on your FTP will have to dig it out...

[Xanthia]

Assuming you mean MySQL:

@daily mysqldump -uusername -ppassword database > /home/user/database-`date +%Y%m%d`.sql

For example:

@daily mysqldump -uxan -pnotmypass xandb1 > /home/xan/xandb1-`date +%Y%m%d`.sql

would produce the file

xandb1-20110727.sql

assuming I ran it when I posted this reply - but every day would produce a new .sql dumpfile with a different date-stamp.

Far from perfect, but it provides a limited backup capabaility. Look at the options to mysqldump to fine tune it.

@daily btw is equivalent to 0 0 * * *