List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 3 2001 1:01pm
Subject:Re: restoring a database on nt4
View as plain text  
Whith Unix it is:
mysql database < logfile.

Pete Kuczynski wrote:

> I can't seem to find any documentation on how to set this up an a
> windowz box.
> 
> Can anyone help?
> 
> Pete
> 
> Gerald Clark wrote:
> 
>> Run your transaction log against the restored database.
>> 
>> Pete Kuczynski wrote:
>> 
>> 
>>> Hoping someone can point me in the right direction.
>>> 
>>> I have Nusphere Mysql database in production [using mysql/PHP/apache, no
>>> perl]. The database has 1 table, 20 columns, with 3500 entries and
>>> growing.
>>> I am backing up the database to tape 2 times a day. At noon and at 5pm,
>>> both are full backups.
>>> 
>>> Let's say the disk should crask at 4pm, one hour prior to the next full
>>> backup.
>>> 
>>> Now I restore the database from the noon backup, how do I restore 4
>>> hours worth of transactions, so the database is up to date?
>>> 
>>> Again, the Mysql database is on a NT4.0 server.
>>> 
>>> Thanks in advance for any insight!
>>> 
>>> 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-thread78215@stripped>
>>> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>> attachment.txt
>>> 
>>> Content-Type:
>>> 
>>> text/plain
>> 
>> --
>> Gerald L. Clark
>> gerald_clark@stripped
>> 
>> ---------------------------------------------------------------------
>> 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-thread78229@stripped>
>> To unsubscribe, e-mail
> <mysql-unsubscribe-pkuczyns=us.dhl.com@stripped>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
restoring a database on nt4Pete Kuczynski2 Jul
  • Re: restoring a database on nt4Gerald Clark2 Jul
  • Re: restoring a database on nt4Pete Kuczynski2 Jul
  • Re: restoring a database on nt4Gerald Clark3 Jul