Heinrich, Tilo wrote:
hello!
now, is it correct that the approach is this: scan the output of backup_history_list for the last log id that was succefully imported. then identify all logbackup-files with an extension that is numerically higher than this and recover_start <medium> <extension of file> for each of them.
If you end log restores in between individual log files with recover_cancel, it might be needed to reapply one or more log backups more than once. So if you use recover_cancel in your script, you should use the "Used LOG Page"-value of db_restartinfo and the 8-th and 9-th column of backup_history_list and backup_history_listnext to find the log backup needed for continuing the log restore. The "Used LOG Page"-value must be in the interval given of 8-th and 9-th column of backup_history_list/next.
this shiver that went down my spine makes me never use recover_cancel. my script just wont support that :)
thank you very much again,
Raimund-- 7. RedDot Anwendertagung der RedDot Usergroup e.V. am 31.1.2005 Pinuts pr�sentiert neue Entwicklung, http://www.pinuts.de/news
Pinuts media+science GmbH http://www.pinuts.de Dipl.-Inform. Raimund Jacob [EMAIL PROTECTED] Krausenstr. 9-10 voice : +49 30 59 00 90 322 10117 Berlin fax : +49 30 59 00 90 390 Germany
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
