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?.

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.

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

Reply via email to