Re: MySQL backup software
| From: | Frank Flynn | Date: | Wed, 27 Oct 2004 21:06:24 +0000 |
| Subject: | Re: MySQL backup software | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-37054@lists.php.net to get a copy of this message | ||
There must be a dozen solutions here; mysqldump and cron come to mind but you haven't been very specific with your needs.
Is your database server Windows or Unix? Can you write a simple script (or modify an example) to fit your needs? What are you going to back up to? Another server? Tape? A different disk on your server? The same disk? (bad idea on so many levels).
Why are you backing up? Disaster recovery? History? Data integrity? How big is the DB(s)? How often to you intend to back up? Or if you did crash and burn and had to go back to a back up how much data (how long) could you tolerate loosing?
It's a kind of interesting discussion and the only wrong answers are not to back up and perhaps to back up to the same disk if you want to be able to recover. But if you answer these questions we'll give you some options.
Frank
On Oct 27, 2004, at 6:57 AM, "Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@fmo.hctx.net>t wrote:
From: "Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@fmo.hctx.net> Date: October 27, 2004 6:57:57 AM PDT To: php-db@lists.php.net Subject: MySQL backup software Does anyone know a free MySQL backup program to schedule regular backups?