You are not logged in.
Anyone who knows of a program or bash script that enables one to make automated backups of websites that are accessible via ftp and mysl? Preferably avaiable in the repositories, but not required.
Offline
wget can do such things. The process is called "mirror", so I guess now you'll find out how this works using a search engine. E.g. http://www.linuxjournal.com/content/dow … -site-wget
Offline
Aha, sorry - that's not exactly what I meant I am developing many websites, and as they are continually dynamically adding content I don't want a system crash or a hacker have the last word.... so I want to be smart and make have an automated system that takes backup of my websites, as stated in my initial post, via FTP and MySQL.
Thank you any way sir
Offline
I think this: http://www.site-vault.com/ is a good example of what could be a nice GUI solution to the problem, but I am also fine with a script. However, my googling attempts failed me in finding such a script or program for Linux...
Offline
I did used a cronjob that executed an script that used mysqldump to dump the entire databases to an sql file, then used rdiff-backup to have incremental backups of that file. (the back up was done over ssh, so it was stored on my local pc)
That way I can return any moment on time of the database history.
"open source is about choice"
No.
Open source is about opening the source code complying with this conditions, period. The ability to choose among several packages is just a nice side effect.
Offline
Hi! Thank you for the suggestion. The problem however is still that I need to do it via FTP as I do not have a SSH connection to my web hotel, they do not offer that...
Offline
This should clone ftp contents to 'backup' directory:
lftp -u login,password -e 'mirror . backup' ftp.site.com
Mysql can be backed up with mysqldump:
mysqldump -h mysql.site.com -u username --password=password --all-databases > mysql-backup.sql
"man lftp" and "man mysqldump" for more info :).
Offline
Thanks!
That seems to be more or less what I am looking for
Offline
Aha, sorry - that's not exactly what I meant I am developing many websites, and as they are continually dynamically adding content I don't want a system crash or a hacker have the last word.... so I want to be smart and make have an automated system that takes backup of my websites, as stated in my initial post, via FTP and MySQL.
Thank you any way sir
Create a CVS repo for each project and make a commit with every little update. If anything goes wrong, you can just overwrite your FTP repo with everything you have backed up. It's a much more hands-on approach, but if something as supposedly reliable your FTP storage is failing, then depending on an automated program to save you isn't the best plan.
EDIT: Not sure how good an idea this is for a MySQL database, though...
Last edited by ANOKNUSA (2013-02-09 15:23:08)
Offline
Thank you! Looking into it
Offline