Very cool. Thaks very much Simon! Pete Simon Green wrote: > > Hi Pete > To emable loffing use the --log option eg --log-update when stating the > server... > > Simon > > -----Original Message----- > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] > Sent: 10 July 2001 17:51 > To: Simon Green > Subject: Re: backup/restore of mysql > > Hi, > do I need to generate these logs using the my.ini file on NT. > > Pete > > Simon Green wrote: > > > > You can use update/bin_update logs..... > > Run these logs from the time of the last backup and it should take you DB > up > > to date till the time in went down.... > > > > Simon > > PS update logs have all the SQL statements in them so it should be very > > simple to recover! > > > > -----Original Message----- > > From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] > > Sent: 10 July 2001 16:00 > > To: [EMAIL PROTECTED] > > Subject: backup/restore of mysql > > > > 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 > > -- > _______________________________________ > Pete Kuczynski > Sr. Field Engineer > DHL Airways Inc. > Infrastructure Technology & Services > (773)-462-9758 > 24/7 Helpdesk 1-800-434-5767 -- _______________________________________ 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
