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