Re: mysql backup solution

You could always try replicating the MySQL Databases to another instance of MySQL running on a different server. As soon as one record is added/updated on one server the slave is updated almost instantly. This way you don't have to worry about backing up all the data in one go. there is a how to on http://www.mysql.com and plenty more if you google for them. Just a thought. Rob ----- Original Message ----- From: "John Kaspar" <ljbn@hotmail.com> To: <php-general@lists.php.net> Sent: Friday, April 25, 2003 9:48 PM 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 > > >