At 11:50 -0500 13/10/05, Jeremy Dunck wrote:
On 10/13/05, SJ <2.718281828(a)gmail.com> wrote:
In particular, two people (Gordon Joly and
Fernanda Viegas) have asked
me in the last week if there were such an option.
What would be an appropriate price markup for this?
And where are those two folks?
I think I misunderstood this thread when I emailed SJ offlist....
:-)
No matter.
***
I am currently working with a general mysql database backup suite
written in PHP4, which does offer a "mail me the data" option, as
well as option to FTP the "backup archive" to distinct server.
However, the software is no longer being developed, as far as I can
see, and has the limitations of PHP (memory). It works well for small
datasets, but I am having a problem with larger datasets possibly due
to server configurations beyond my control.
Here is a flavour for what happens....
******************************************************************
MySQL database backup $Revision: 1.22 $
Copyright (c) 2003, 2004 by Alain Wolf, Zurich - Switzerland
Website:
http://restkultur.ch/personal/wolf/scripts/db_backup/
----------------------------------------------------------------------
PHP 4.3.2 - SAPI: apache2filter - OS: Linux - PHP Safe-Mode: Off
----------------------------------------------------------------------
Starting backup on
www.dead-pubs-society.org.uk
Friday 14. October 2005 09:54 BST
----------------------------------------------------------------------
Configuration Settings:
Backup to: /dead-pubs-society.org.uk/wiki_data
Weekly Backup: No
Monthly Backup: No
Keeping daily backups for 7 days
Keeping weekly backups for 4 weeks
Keeping monthly backups for 3 months
Archiving SQL files: Yes
Archive filename prefix:
Remove SQL-files after archiving: Yes
Compress archive-file: Yes
Send reports by email: Yes
Send backup archive by email: No
Send email message to: brew.master(a)dead-pubs-society.org.uk
Upload backup archive to FTP server: No
----------------------------------------------------------------------
09:54:29: Diskspace used by MySQL database backup files: 941.8 KB
----------------------------------------------------------------------
09:54:29: Beginning backup of MySQL database msx1db22a63 ...
-----------------------------------------------------------
******************************************************************
Here is the start of the README file
-------------
MySQL database backup is a database backup script written in PHP4.
Most people will used it to have a daily snapshot of the dynamic data
on their website. (e.g. content management systems, forums,
guestbooks etc.)
The script reads all tables in the MySQL databases you coose and
exports (dumps) them in SQL files.
The generated SQL files can be used to rebuild the tables on any
other MySQL database or server or on the same server in case of data-
loss.
-------------
See
http://restkultur.ch/personal/wolf/scripts/db_backup/
Gordo
--
"Think Feynman"/////////
http://pobox.com/~gordo/
gordon.joly(a)pobox.com///