RE: Backup automation..

2002-08-02 Thread Alec . Cawley
> If you've got to make copies to disk then why not just maintain copies on > disk via replication? Stop the slave, backup the slave, restart the slave. In my case, replication is installed to give 24/7 service even if one of the server dies for some reason. When both master and slave are up, I

Re: Backup automation..

2002-07-31 Thread Gerald R. Jensen
s --force --opt --verbose --databases customers>n:\dbbakup\customers.sql The AT command looks like: at 01:00 /every:M,W,F cmd.exe /c "c:\winnt\dbbak.cmd" - Original Message - From: "Nixarlidis Aris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

RE: Backup automation..

2002-07-31 Thread Orr, Steve
EMAIL PROTECTED] Subject: RE: Backup automation.. Aye, I forgot to mention to lock the db before backing up...my bad. But again the idea is the same just schedule win2k to do it. -Nick Ed Carp said: >> >> On windows you could simply copy the entire data directory with a >> Sch

Re: Backup automation..

2002-07-31 Thread Mark Stringham
31, 2002 8:54 AM Subject: RE: Backup automation.. > Aye, I forgot to mention to lock the db before backing up...my bad. But > again the idea is the same just schedule win2k to do it. > > -Nick > > Ed Carp said: > >> >> On windows you could simply copy the entir

RE: Backup automation..

2002-07-31 Thread Nicholas Stuart
Aye, I forgot to mention to lock the db before backing up...my bad. But again the idea is the same just schedule win2k to do it. -Nick Ed Carp said: >> >> On windows you could simply copy the entire data directory with a >> Scheduled job. Copying the files should be all you need to do for >> win

RE: Backup automation..

2002-07-31 Thread Ed Carp
> >> On windows you could simply copy the entire data directory with a > >> Scheduled job. Copying the files should be all you need to do for > windows. > >> For a cleaner, and what most people would say is a better way you could > >> schedule a batch file to run mysqldump that would dump the data

RE: Backup automation..

2002-07-31 Thread Alec . Cawley
>> On windows you could simply copy the entire data directory with a >> Scheduled job. Copying the files should be all you need to do for windows. >> For a cleaner, and what most people would say is a better way you could >> schedule a batch file to run mysqldump that would dump the data and >>

RE: Backup automation..

2002-07-31 Thread Ed Carp
> -Original Message- > From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 8:38 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Backup automation.. > > On windows you could simply copy the entire data directory with a >

Re: Backup automation..

2002-07-31 Thread Nicholas Stuart
On windows you could simply copy the entire data directory with a Scheduled job. Copying the files should be all you need to do for windows. For a cleaner, and what most people would say is a better way you could schedule a batch file to run mysqldump that would dump the data and structure to a fi

Backup automation..

2002-07-31 Thread Nixarlidis Aris
Hi, I am looking for a way to automate the way i take backups. I run mysql on w2k server and I seek for a way to take backups of the database at certain times automaticaly. Is out there any suggestion? thanks.. - Before postin