Re: problem restoring from binary log

2007-04-27 Thread Mathieu Bruneau
Ofer Inbar a écrit : > Mathieu Bruneau <[EMAIL PROTECTED]> wrote: >> Ofer Inbar a écrit : >>> I can repeat the problem with this procedure on the test db: >>> - Import a full mysqldump file from the prodution db >>> - flush logs >>> - run a full mysqldump with --flush-logs --master-data=2 >>> -

Re: problem restoring from binary log

2007-04-27 Thread Ofer Inbar
Mathieu Bruneau <[EMAIL PROTECTED]> wrote: > Ofer Inbar a écrit : > > I can repeat the problem with this procedure on the test db: > > - Import a full mysqldump file from the prodution db > > - flush logs > > - run a full mysqldump with --flush-logs --master-data=2 > > - do a bunch of stuff tha

Re: problem restoring from binary log

2007-04-27 Thread Mathieu Bruneau
Ofer Inbar a écrit : > I'm trying to set up MySQL backup & restore using mysqldump and binary > logs, so we can run mysqldump infrequently and use binary logs for the > daily backups (because mysqldump makes the production database unusable > for too long a time to run every night). > > - I can m