Eric Lamendola wrote: > Hey, > > I thought you could just use > > mysqladmin refresh -pPASSWORD -- or > mysqladmin reload -pPASSWORD > > To kickstart logging again? > > If not - hey, what do I know <heh> > > Eric Lamendola > Yeah that only restarts the binary log. I like to have a human-readable log which I can run through for when I screw up a query badly (or someone else does something just as silly) and have to recover by restoring from a backup, editing the transaction log and handing it back through the mysql client:
mysql < log_without_stupid_mistake -pPASSWORD I've had to do this a few times now... As far as I know you can't do this very easily with the binary log. Anyway, I feel a lot better knowing I can see something human-readable. I like watching my logs, OK? :) And I want them broken up by the day so they're managable. Is there a way of making mysql also restart the non-binary (pure sql) log? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com --------------------------------------------------------------------- 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
