> 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
I would use the Windows 'AT' command (make sure the Scheduler service is
running) to call a .CMD script with a mysqldump query.
Here's one we use ... the filename is dbbak.cmd:
mysqldump --all --add-drop-table --add-locks --complete-insert --compress --
extended-insert --flush-logs --force --opt
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
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
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
> >> 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
>> 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
>>
> -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
>
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
