Ok, figured hout hot do generate the update logs, and to rotate the logs, but, cant seem to upload the logs. >From mysql/bin: The statment: mysql -u root -p<mypassword> --one-database <mydatabasename> < update.1 generates the error that it cannot find the update file. How do I tell mysql where the update log is. Currently it's in d:\mysql\bin Pete -------- Original Message -------- Subject: RE: backup/restore of mysql Date: Tue, 10 Jul 2001 17:48:31 +0100 From: Simon Green <[EMAIL PROTECTED]> To: "'Pete Kuczynski'" <[EMAIL PROTECTED]> 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 --------------------------------------------------------------------- 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