RE: [PHP] mysql backup solution

From: Date: Fri, 06 Jun 2003 15:44:34 +0000
Subject: RE: [PHP] mysql backup solution
Groups: php.general 
Request: Send a blank email to php-general+get-150508@lists.php.net to get a copy of this message
This is what I use http://members.lycos.co.uk/wipe_out/automysqlbackup/ -----Original Message----- From: John Kaspar [mailto:ljbn@hotmail.com] Sent: Friday, April 25, 2003 3:48 PM To: php-general@lists.php.net 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

« previous php.general (#150508) next »