On 2007.08.01. 16:16, Drew Bentley wrote:
...
>> if you really need incremental backups, i don't know of any other method
>> than using binlogs
>> --
>> Rich
>>
> Yes, in order to do incrementals, you'll need binlogs enabled and
> you'll need to back these up. But also consider they take or can t
On 8/1/07, Rich <[EMAIL PROTECTED]> wrote:
> On 2007.08.01. 15:33, Dimitrios wrote:
> > On Wed, 01 Aug 2007 15:20:50 +0300 Rich <[EMAIL PROTECTED]> wrote:
> >
> >> i still prefer dumps, they are more portable, easier to restore and
> >> compress better.
> >
> > but what about incremental backups? a
On 2007.08.01. 15:33, Dimitrios wrote:
> On Wed, 01 Aug 2007 15:20:50 +0300 Rich <[EMAIL PROTECTED]> wrote:
>
>> i still prefer dumps, they are more portable, easier to restore and
>> compress better.
>
> but what about incremental backups? as far as i know, you'd have to backup
> the entire da
On 2007.08.01. 15:31, Dimitrios wrote:
> On Wed, 01 Aug 2007 14:51:43 +0300 Rich <[EMAIL PROTECTED]> wrote:
...
>> other method might be feeding mysqldump output to pipe, where data is
>> directly picked up by bacula client (i think, this was implemented
>> somewhere around 2.0 bacula).
>> has th
On Wed, 01 Aug 2007 15:20:50 +0300 Rich <[EMAIL PROTECTED]> wrote:
> i still prefer dumps, they are more portable, easier to restore and
> compress better.
but what about incremental backups? as far as i know, you'd have to backup the
entire database over and over again and for a very large dat
On Wed, 01 Aug 2007 14:51:43 +0300 Rich <[EMAIL PROTECTED]> wrote:
> using innodb, it should be possible to dump all tables as a single
> transaction.
indeed, unfortunately our MySQL has a mix of innodb and myisam tables.
> other method might be feeding mysqldump output to pipe, where data is
On 2007.08.01. 14:51, Rich wrote:
> On 2007.08.01. 14:37, Dimitrios wrote:
>> Based on my research, i found out that backing up MySQL is quite
>> un-efficient.
>>
>> On a small database, you can just dump the contents of MySQL into a file and
>> then backup that file.
>>
>> On a large database (s
machine at the instant of backing up, unless
MySQL is actually VSS aware?
James
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:bacula-users-
> [EMAIL PROTECTED] On Behalf Of Dimitrios
> Sent: Wednesday, 1 August 2007 21:37
> To: bacula-users@lists.sourceforge.net
On 2007.08.01. 14:37, Dimitrios wrote:
> Based on my research, i found out that backing up MySQL is quite un-efficient.
>
> On a small database, you can just dump the contents of MySQL into a file and
> then backup that file.
>
> On a large database (several Gigs) dumping to a file should be avo
Based on my research, i found out that backing up MySQL is quite un-efficient.
On a small database, you can just dump the contents of MySQL into a file and
then backup that file.
On a large database (several Gigs) dumping to a file should be avoided, for
example, on a hosting service the dump c
On Tue, July 31, 2007 2:36 pm, David Romerstein wrote:
> On Tue, 31 Jul 2007, Troy Daniels wrote:
>
>> Just curious, but is there a reason you did it this way around instead
>> of
>> having a 'ClientRunBeforeJob' script launch the dump process from within
>> Bacula?
>>
>> You end up with the same
On Tue, 31 Jul 2007, Troy Daniels wrote:
> Just curious, but is there a reason you did it this way around instead of
> having a 'ClientRunBeforeJob' script launch the dump process from within
> Bacula?
>
> You end up with the same result in the end I guess and I was wondering if
> there was mor
Hi,
Just curious, but is there a reason you did it this way around instead
of having a 'ClientRunBeforeJob' script launch the dump process from
within Bacula?
You end up with the same result in the end I guess and I was wondering
if there was more to it than just personal preference.
Cheers,
On Mon, 30 Jul 2007, Dimitrios wrote:
> I'm already using mysqldump to create archives of my database, but i
> don't see how Bacula can execute mysqldump during its backup process.
> I'll search the docs to see if there is support for such a thing.
Reverse your thinking - let your mysqldump pro
On Mon, 30 Jul 2007 09:08:16 +0200 Luca Ferrari <[EMAIL PROTECTED]> wrote:
> I'm not sure this is related to bacula. MySQL provides a tool, called
> mysqldump, that can be used to dump the data of a database and to rebuild it.
> I guess this is what you are looking for, even if there are other s
Hi,
> What is the best way to backup MySQL databases?
> I've got a few web servers that i'd like to backup, which rely heavily on
> MySQL for offering dynamic content.
> Should i just backup the "/var/lib/mysql/*" directly? Does that mean i have
> to shutdown the MySQL process during the backup?
On Monday 30 July 2007 Dimitrios's cat, walking on the keyboard, wrote:
> What is the best way to backup MySQL databases?
>
> I've got a few web servers that i'd like to backup, which rely heavily on
> MySQL for offering dynamic content.
>
> Should i just backup the "/var/lib/mysql/*" directly? Doe
17 matches
Mail list logo
