Automated backup (uploaded files + mysql db), compression and retrieval
-
Hi, great tutorials!
I'm looking for a backup solution, I'm pretty sure you have done something similar and being a total newbie to linux I'd appreciate your help.
Here are the requirements:
a) backup folders a, b and c (folders where user upload content, photos, text, videos etc). Zip or gzip, saving full path info.
B) backup mysql database, gzipping the file.
C) zip A) + B) like "backup-2010-02-23.zip" and leave it at directory D
D) sftp and download it regularly. This one I can automate and do it myself :)
Could you help me with items a,b and c?
I've subscribed to your website, it's worth much more than the subscription price, thank you for sharing your knowledge.
Leo
Posted 1 year ago # -
hey Leonardo, tx for your kind words, Sir.
I'm planning a couple of tuts on this .. and will be in the next 2-3 weeks .. it's high on the priority list, (just got higher due to this post!)
basically, if you can't wait, what you need to do for your static web files is create a "rsync cron job" .. but I'll be detailing it precisely ..
.. together with what you need to do to auto backup your db, emailed to you being an option.
Posted 1 year ago # -
Looking forward to your backup tutorial Mr guv
Posted 1 year ago # -
I am also eagerly awaiting your back up tutorial Guv.
Posted 1 year ago # -
yes, of course. agreed!
.. just have to run of this spate of PHP though .. probably 3/4 more posts on that, and I figured I should compare some caching systems too
.. but OK .. i'll bump the backup.
Posted 1 year ago # -
I have a suggestion for the backup tutorial.
The tool mysqldumper ( http://www.mysqldumper.net/ )
It allows database backups via a php script and/or a perl script.
(automatic upload to an ftp of your choice and many things more)
It can also be used as a phpmyadmin alternative ;)Posted 1 year ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.
