Re: table backups

2002-02-26 Thread Nathan
- From: "Mark Stringham" <[EMAIL PROTECTED]> To: "Nathan" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 11:26 AM Subject: Re: table backups Ok - I am going to show my complete ignorance here now. How do I configure my

Re: table backups

2002-02-26 Thread Mark Stringham
<[EMAIL PROTECTED]> To: Mark Stringham <[EMAIL PROTECTED]>; MySQL <[EMAIL PROTECTED]> Date: Tuesday, February 26, 2002 10:53 AM Subject: Re: table backups >1. Task Scheduler. Every 32-bit flavor of Windows has a task scheduler, and you can have it execute >batch scripts

Re: table backups

2002-02-26 Thread Nathan
... ? # Nathan - Original Message - From: "Mark Stringham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 10:22 AM Subject: Re: table backups 2 quick questions - 1. What is the Windows equivelant to a cron job. I would like to perform a

Re: table backups

2002-02-26 Thread Mark Stringham
2 quick questions - 1. What is the Windows equivelant to a cron job. I would like to perform an automated back-up of MySQL tables and data on a Win 2K server.. 2. Is mysqlhotcopy always performed from the command line? Thanks Mark -Original Message- From: Victoria Reznichenko <[EMAIL

Re: table backups

2002-02-26 Thread alec . cawley
> Direct copying files is not recommended way to backup databases. Is this true even for a "dormant" system? I plan to have a pair of replicated servers. I intended to do backup by stopping the slave, copying the files, then starting the slave again (at which point I hope it will catch up with up

Re: table backups

2002-02-26 Thread Stewart G.
Ive seen the mysql documentation and that why I ask this question. The docs just confuse me because the mysqldump page says mysqlhotcopy is the preferred way, and vice versa. The docs seem to favor mysqlhotcopy but then the page also says only to use it when your sure data isnt being written.