powered by
Socialbar
Socialbar
Home | Downloads | Credits and Licence | Forum | Bug Tracker
genQL is a bash script aimed at automatizing our web server
backup process, and to ease the restore process.
We have been looking for an open source app that would meet our
requirements and couldn't find it.
Our requirements where the following:
- The program should run on a *nux backup server, that had no services activated (security), as such,
the backup script must contact the backed up server, and not otherwise.
- It's administration and use should be centralised, minimising the work to do on the backed up servers.
- It should be able to backup some web sites (files and DB), through ftp and sftp, basing itself on lists.
- It must have as few dependencies as possible (compared to debian minimal netinstall).
- It must be lightweight.
- It needs to be cron launchable, or usable trough console interface (no gui nor web-interface wanted).
- It needs some internal "pseudo cron" system, allowing to program individual timings for sites backups.
- It needs to be able to restore the backups (and the db) from the easiest and fastest way possible.
- It should report errors to it's admin.
I thus decided to start the task of doing my own, our main problem in this perspective was to trigger
the mysqldump from our backupserver, while on some servers we are limited to ftp access (ssh would have
been too easy :s). This is where the script's name comes from: GENerate SQL
So I spent last week in front of nano, and then thought somebody else could
a use for this simple script, as well as I could allways enjoy advice or help.
The first lines of the script where written on the 29th of December 2009, this page
thus appears today in celebration of it's first week aniversary!
I thus sincerely apologize for the poor looking of this site, but would rather spend
my time on further developping the script itself.