Cron daily backup script

[taha116]

Does anyone know of a simple script i could use that would use cron jobs to create daily/weekly backups of my home directory and maybe my databases.

Anything related is welcome
Edit:
* Bump
No 1 has a suggestion? I really would find 1 useful.

[gomarc]

Not long ago I found this application. It’s called phpMyBackupPro. Very easy to use, free, licensed under the GNU GPL.

I just finished testing on my free account and it works really great.

You’ll be happy to see that you can backup your databases on a regular schedule.

Link to application: phpMyBackupPro

[Livewire]

Only worry I'd have is with high-resource usage possibly being an issue.

The alternative to backing up the home directory is some sort of locally based (read: on your pc, not x10) that FTP's to x10 every week and recursively downloads everything it finds.


That won't cover databases, but that should be okay to do with php without triggering high-resource usage.

I'd just be worried about zipping the entire root, particularly if you've got big files anywhere on there.

[taha116]

Well i understand what livewires talking about but i think gomarcs solution is better as i have no idea how to pull that off with ftp automaticly

[gomarc]

Please note that the suggested application only targets your MySQL databases.

I haven’t found a similar application for the website yet.

[taha116]

I went to thier site but i didnt realise that. So if i understand correctly it wont backup my public_html files?

[gomarc]

You understood correctly, taha116.

The application mentioned above will only generate backups of your MySQL databases, which is in fact a pretty big task all by itself.

[leafypiggy]

It's not hard to backup sql databases.

PHPmyAdmin -> export -> save as .sql.

Repeat for every database, should really only take a few minutes.

[taha116]

Well yeah, lol but autmated is usefull, when your focused on some code or modification you want to preform manually you know there is always a risk, i hate it when i have to backtrack like a week of changes and do em again