At 11:50 -0500 13/10/05, Jeremy Dunck wrote:
On 10/13/05, SJ 2.718281828@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@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