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 <[EMAIL PROTECTED]>
>>> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>> attachment.txt
>>>
>>> Content-Type:
>>>
>>> text/plain
>>
>> --
>> Gerald L. Clark
>> [EMAIL PROTECTED]
>>
>> ---------------------------------------------------------------------
>> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
