This is what I use http://members.lycos.co.uk/wipe_out/automysqlbackup/

-----Original Message-----
From: John Kaspar [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2003 3:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql backup solution


I've got a large mysql database (~400 megs) on a host that I need to 
backup regularly. If I use phpMyAdmin's dump features, it just freezes.

I've currently got a php script that goes thru each table and backs up 
about 10,000 records iteratively (for example accounts1.txt, 
accounts2.txt).  But it just backs them up to the host itself.

(a) I need it to zip up the files to make them smaller, (b) I would like 
the script to save the zipped files to a designated folder on my local 
harddrive via ftp download (without me having to say where, or giving it 
an okay).

Is that possible? Does someone have a better backup method?
Thanks, John


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to