On 04/16/2012 10:38 AM, Martin Simmons wrote:
> I think it should be impossible to make a database backup that represents a
> point in the middle of anything. By "should be impossible" I mean that either
> MySQL should always prevent it or database clients should use MySQL in such a
> way that all
> On Fri, 13 Apr 2012 21:47:04 +0100, Joe Nyland said:
>
> On 13 Apr 2012, at 18:14, Martin Simmons wrote:
>
> >> On Wed, 11 Apr 2012 11:09:12 +0100, =?utf-8?Q?Joe Nyland?= said:
> >>
> >> Ok, firstly: sorry for not following up sooner. There have been several
> >> replies for this threa
> On Fri, 13 Apr 2012 14:13:41 -0400, Phil Stracchino said:
>
> On 04/13/2012 01:02 PM, Martin Simmons wrote:
> >> On Tue, 10 Apr 2012 15:27:22 -0400, Phil Stracchino said:
> >> You shouldn't think of a temporary table as persistent DB data. Think
> >> of them instead as part of the trans
On 04/13/2012 04:47 PM, Joe Nyland wrote:
> I seem to have settled on the suggestion that maybe I should't worry
> about these temporary tables too much. As I think Phil is trying to
> explain; if there were a way in which these temporary tables could be
> backed up and restored somehow, then the a
On 13 Apr 2012, at 18:14, Martin Simmons wrote:
>> On Wed, 11 Apr 2012 11:09:12 +0100, =?utf-8?Q?Joe Nyland?= said:
>>
>> Ok, firstly: sorry for not following up sooner. There have been several
>> replies for this thread since my last reply, so thanks everyone for your
>> input.
>>
>> Phil,
On 04/13/2012 01:02 PM, Martin Simmons wrote:
>> On Tue, 10 Apr 2012 15:27:22 -0400, Phil Stracchino said:
>> You shouldn't think of a temporary table as persistent DB data. Think
>> of them instead as part of the transient state of a single ongoing
>> transaction. Is it a reasonable expectat
> On Wed, 11 Apr 2012 11:09:12 +0100, =?utf-8?Q?Joe Nyland?= said:
>
> Ok, firstly: sorry for not following up sooner. There have been several
> replies for this thread since my last reply, so thanks everyone for your
> input.
>
> Phil, you point out that the problem here is most likely to do
> On Tue, 10 Apr 2012 15:27:22 -0400, Phil Stracchino said:
>
> On 04/10/2012 02:15 PM, Martin Simmons wrote:
> > Sorry, I didn't mean mysqldump on its own.
> >
> > The MySQL documentation suggests that you can make a backup from the output
> > of
> > mysqldump plus later binlogs and then us
-Original message-
From: Phil Stracchino
Sent: Tue 10-04-2012 20:30
Subject:Re: [Bacula-users] Bacula MySQL Catalog binlog restore
To: bacula-users@lists.sourceforge.net;
> On 04/10/2012 02:15 PM, Martin Simmons wrote:
> > Sorry, I didn't mean mysqld
On 04/10/2012 07:51 AM, Joe Nyland wrote:
> -Original message-
> From: Joe Nyland
> Sent: Fri 06-04-2012 22:15
> Subject: Re: [Bacula-users] Bacula MySQL Catalog binlog restore
> To: Bacula Users;
>> On 6 Apr 2012, at 00:08, Phil Stracchino wrote:
>>
On 04/10/2012 02:15 PM, Martin Simmons wrote:
> Sorry, I didn't mean mysqldump on its own.
>
> The MySQL documentation suggests that you can make a backup from the output of
> mysqldump plus later binlogs and then use them to restore a database, but what
> use is that if it doesn't work with tempo
> On Tue, 10 Apr 2012 12:44:25 -0400, Phil Stracchino said:
>
> On 04/10/2012 12:27 PM, Martin Simmons wrote:
> >> On Tue, 10 Apr 2012 11:15:29 -0400, Phil Stracchino said:
> >>
> >> On 04/10/2012 10:51 AM, Joe Nyland wrote:
> >>> I'm a bit ashamed to admit I'm still battling this! I've re
On 04/10/2012 12:27 PM, Martin Simmons wrote:
>> On Tue, 10 Apr 2012 11:15:29 -0400, Phil Stracchino said:
>>
>> On 04/10/2012 10:51 AM, Joe Nyland wrote:
>>> I'm a bit ashamed to admit I'm still battling this! I've removed
>>> '--delete-master-logs' from my mysqldump line, but it hasn't helped
> On Tue, 10 Apr 2012 11:15:29 -0400, Phil Stracchino said:
>
> On 04/10/2012 10:51 AM, Joe Nyland wrote:
> > I'm a bit ashamed to admit I'm still battling this! I've removed
> > '--delete-master-logs' from my mysqldump line, but it hasn't helped.
> >
> > For some reason, it seems as if the d
On 04/10/2012 10:51 AM, Joe Nyland wrote:
> I'm a bit ashamed to admit I'm still battling this! I've removed
> '--delete-master-logs' from my mysqldump line, but it hasn't helped.
>
> For some reason, it seems as if the dump does not contain any mention
> of the temporary tables being created, nei
-Original message-
From: Joe Nyland
Sent: Fri 06-04-2012 22:15
Subject:Re: [Bacula-users] Bacula MySQL Catalog binlog restore
To: Bacula Users ;
> On 6 Apr 2012, at 00:08, Phil Stracchino wrote:
>
> > On 04/05/2012 06:46 PM, Stephen Thompson wrote:
> >
On 6 Apr 2012, at 23:52, Konstantin Khomoutov wrote:
> On Thu, Apr 05, 2012 at 11:19:00PM +0100, Joe Nyland wrote:
>
> [...]
>> mysqldump --all-databases --single-transaction --delete-master-logs \
>> --flush-logs --master-data --opt -u ${DBUSER} -p${DBPASS} \
>>> ${DST}/${HOST}_${DATE}_${TIME}.
On Thu, Apr 05, 2012 at 11:19:00PM +0100, Joe Nyland wrote:
[...]
> mysqldump --all-databases --single-transaction --delete-master-logs \
> --flush-logs --master-data --opt -u ${DBUSER} -p${DBPASS} \
> > ${DST}/${HOST}_${DATE}_${TIME}.sql.dmp
[...]
I don't have an answer to the problem being
On 6 Apr 2012, at 00:08, Phil Stracchino wrote:
> On 04/05/2012 06:46 PM, Stephen Thompson wrote:
>> On 04/05/2012 03:19 PM, Joe Nyland wrote:
>>> As I think it may be useful, here's the line taken from my MySQL
>>> 'RunBeforeJob' script when the full backup is taken:
>>>
>>> mysqldump --all-data
On 04/05/2012 06:46 PM, Stephen Thompson wrote:
> On 04/05/2012 03:19 PM, Joe Nyland wrote:
>> As I think it may be useful, here's the line taken from my MySQL
>> 'RunBeforeJob' script when the full backup is taken:
>>
>> mysqldump --all-databases --single-transaction --delete-master-logs
>> --flu
On 04/05/2012 03:19 PM, Joe Nyland wrote:
> On 5 Apr 2012, at 22:37, Stephen Thompson wrote:
>
>> On 04/05/2012 02:27 PM, Joe Nyland wrote:
>>> Hi,
>>>
>>> I've been using Bacula for a while now and I have a backup procedure in
>>> place for my MySQL databases, where I perform a full (dump) backup
On 5 Apr 2012, at 22:37, Stephen Thompson wrote:
> On 04/05/2012 02:27 PM, Joe Nyland wrote:
>> Hi,
>>
>> I've been using Bacula for a while now and I have a backup procedure in
>> place for my MySQL databases, where I perform a full (dump) backup nightly,
>> then incremental (bin log) backups
On 04/05/2012 02:27 PM, Joe Nyland wrote:
> Hi,
>
> I've been using Bacula for a while now and I have a backup procedure in place
> for my MySQL databases, where I perform a full (dump) backup nightly, then
> incremental (bin log) backups every hour through the day to capture changes.
>
> I basic
Hi,
I've been using Bacula for a while now and I have a backup procedure in place
for my MySQL databases, where I perform a full (dump) backup nightly, then
incremental (bin log) backups every hour through the day to capture changes.
I basically have a script which I have written which is run a
24 matches
Mail list logo
