Hello,
I use MySQL in a production environment where it is running a few
databases. I make hourly db backups using the perl hot copy script
distributed with MySQL. I would like to be able to restore my db down
to the minute with the binary log, but the options to the binary log
parser are some what limited as far as I can tell. Since it logs
transactions for all the db's and since I can not select just certain
tables or time/date ranges to restore, it seems I would need to output
the log to a file and then parse it with my own script to build a
restore log with just the info I need.
#1 Am I mistaken? Did I not read the docs thoroughly enough? Can I do
these things with the current log parser?
#2 If I do understand it correctly, is there anybody who has already
written such a script?
Thanks for your help.
David
---------------------------------------------------------------------
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