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
AIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, February 26, 2002 8:51 AM Subject: table backups >Stewart, >Tuesday, February 26, 2002, 5:13:58 PM, you wrote: > >SG> I want to create a cron job that does nightly backups of a database, tars >SG&

Re[2]: table backups

2002-02-26 Thread Victoria Reznichenko
Hello alec, Tuesday, February 26, 2002, 6:01:48 PM, you wrote: >> Direct copying files is not recommended way to backup databases. acqc> Is this true even for a "dormant" system? I plan to have a pair of acqc> replicated servers. I intended to do backup by stopping the slave, copying acqc> the

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.

table backups

2002-02-26 Thread Victoria Reznichenko
Stewart, Tuesday, February 26, 2002, 5:13:58 PM, you wrote: SG> I want to create a cron job that does nightly backups of a database, tars SG> and gzips it, then ftps it to another server. SG> I was wondering what the perferred method of copying the data would be. SG> mysqldump, mysqlhotcopy or

table backups

2002-02-26 Thread Stewart G.
I want to create a cron job that does nightly backups of a database, tars and gzips it, then ftps it to another server. I was wondering what the perferred method of copying the data would be. mysqldump, mysqlhotcopy or just copying the files. =S. -