You are not logged in.

#1 2013-02-08 18:15:21

jerik
Member
Registered: 2009-03-02
Posts: 197

Application or script for making backups of external websites

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

#2 2013-02-08 19:40:26

Army
Member
Registered: 2007-12-07
Posts: 1,784

Re: Application or script for making backups of external websites

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

#3 2013-02-08 20:00:07

jerik
Member
Registered: 2009-03-02
Posts: 197

Re: Application or script for making backups of external websites

Aha, sorry - that's not exactly what I meant smile 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 smile

Offline

#4 2013-02-08 20:29:49

jerik
Member
Registered: 2009-03-02
Posts: 197

Re: Application or script for making backups of external websites

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

#5 2013-02-08 20:38:04

chris_l
Member
Registered: 2010-12-01
Posts: 387

Re: Application or script for making backups of external websites

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

#6 2013-02-08 22:37:12

jerik
Member
Registered: 2009-03-02
Posts: 197

Re: Application or script for making backups of external websites

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

#7 2013-02-08 22:50:14

hiciu
Member
Registered: 2010-08-11
Posts: 78

Re: Application or script for making backups of external websites

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

#8 2013-02-09 09:38:46

jerik
Member
Registered: 2009-03-02
Posts: 197

Re: Application or script for making backups of external websites

Thanks!

That seems to be more or less what I am looking for smile

Offline

#9 2013-02-09 15:22:23

ANOKNUSA
Member
Registered: 2010-10-22
Posts: 2,141

Re: Application or script for making backups of external websites

jerik wrote:

Aha, sorry - that's not exactly what I meant smile 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 smile

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... hmm

Last edited by ANOKNUSA (2013-02-09 15:23:08)

Offline

#10 2013-02-09 18:30:57

jerik
Member
Registered: 2009-03-02
Posts: 197

Re: Application or script for making backups of external websites

Thank you! Looking into it smile

Offline

Board footer

Powered by FluxBB