Greg Cope wrote:
> Pete Kuczynski wrote:
>
>> Hi,
>> I've posted this question before, and some were kind enough to respond
>> with suggestions to my question [replication], but I'm looking for
>> something more difinitave.
>>
>> Background: I'm running a production mysql database/php4/Apache on a NT4
>> IBM Netfinity server [3500 records, growing by 100 a day or so]. I do
>> not have the option to go to lunux/unix [company's call not mine].
>> I am backing up the database twice a day, noon and 6 pm.
>>
>> Question: if a disk should crash, I can recover the database from the
>> last tape backup, but not the transactions that took place in between.
>> Is replacation of the database on another box my only option?
>> Dosn't mysql support transaction logging like MSSQL or Oricle, or
>> Postgres?.
>
>
> Yes it does - look for update log in the manual.
>
> But if a disk gets toasted what are you going to do then (with any
> system) ?
>
>
>> I don't wan't to switch to another database, but as this one grows, it's
>> becoming incrisingly important to be able to do a complete database
>> recovery in the event of a crash.
>
>
> Use a proper operating system, with RAID (either hardware or software
> RAID 1, or 5)
>
> Greg
Or keep the backups and logs on another device.
>
>
>
>> Kindest thanks!
>>
>> Pete
>>
>> --
>> _______________________________________
>> Pete Kuczynski
>> Sr. Field Engineer
>> DHL Airways Inc.
>> Infrastructure Technology & Services
>> (773)-462-9758
>> 24/7 Helpdesk 1-800-434-5767
>>
>> ------------------------------------------------------------------------
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
