List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 11 2001 1:01pm
Subject:Re: backup/restore of mysql
View as plain text  

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 <mysql-thread79012@stripped>
>> To unsubscribe, e-mail
> <mysql-unsubscribe-gjjc=rubberplant.freeserve.co.uk@stripped>
>> 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 <mysql-thread79087@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
backup/restore of mysqlPete Kuczynski10 Jul
  • Re: backup/restore of mysqlGreg Cope11 Jul
  • Re: backup/restore of mysqlGerald Clark11 Jul
RE: backup/restore of mysqlSimon Green10 Jul
Re: backup/restore of mysqlPete Kuczynski10 Jul