On Tue, 25 Oct 2011 17:46:43 -0400
Phil Stracchino ala...@metrocast.net wrote:
On 10/25/11 10:41, Konstantin Khomoutov wrote:
MySQLdump is a valid technique, and the simplest working technique.
You should not, as a rule, back up the MySQL data directory at
filesystem level. It is
Hi all,
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is there a better way ? MySQL module for
bacula, backup mysql files (.myd and
Le 25/10/2011 11:13, Dimitri Gourdon a écrit :
Hi all,
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is there a better way ?
Hi,
2011/10/25 Dimitri Gourdon dgour...@itool.com:
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
You can find useful information at:
http://wiki.bacula.org/doku.php?id=application_specific_backups:mysql
Regards,
--
Bertera Pietro
On Tue, 25 Oct 2011 11:13:11 +0200
Dimitri Gourdon dgour...@itool.com wrote:
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is
On Tue, 25 Oct 2011 12:03:37 +0200
Alexandre Chapellon a.chapel...@horoa.net wrote:
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk
and after that, backup that files.
On Tue, 25 Oct 2011 11:13:11 +0200 Dimitri Gourdon dgour...@itool.com
wrote:
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is there
On 10/25/11 05:13, Dimitri Gourdon wrote:
Hi all,
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is there a better way ? MySQL
¡Hi!
you can make a dump of the entire database and then periodically
(once per hour, once every two hours, etc) you can backup MySQL's
binlogs.
Regarding the dump file, it's much better if you dump each database
in its own file instead of having only one big file with all the
First, thanks to all for your quick answers.
I have read about all your solutions. I think for me, the best way will
be a shell script to do local mysqldump on each servers and backup these
files after. This solution seems to be the easiest to deploy and
maintain on tens of servers.
The
On Tue, 25 Oct 2011 07:34:06 -0400
Phil Stracchino ala...@metrocast.net wrote:
[...]
MySQLdump is a valid technique, and the simplest working technique.
You should not, as a rule, back up the MySQL data directory at
filesystem level. It is extremely unlikely to yield a consistent
backup. If
Hello,
On Tue, 25 Oct 2011 07:34:06 -0400, Phil Stracchino wrote:
MySQLdump is a valid technique, and the simplest working technique.
You
should not, as a rule, back up the MySQL data directory at filesystem
level. It is extremely unlikely to yield a consistent backup. If
you're going
On 10/25/11 10:41, Konstantin Khomoutov wrote:
MySQLdump is a valid technique, and the simplest working technique.
You should not, as a rule, back up the MySQL data directory at
filesystem level. It is extremely unlikely to yield a consistent
backup. If you're going to attempt this, issue a
On 10/25/11 11:03, Jérôme Blion wrote:
With mylvmbackup, you can backup any type of engine which writes on
disk (don't expect to recover memory table...) as long as you flush
buffers to disk.
Yup. The issue is that should you get something NOT completely flushed,
InnoDB has built in error
On Oct 25, 2011, at 5:13 AM, Dimitri Gourdon wrote:
Hi all,
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after that, backup that files. Is there a better
On 10/25/11 21:36, Dan Langille wrote:
On Oct 25, 2011, at 5:13 AM, Dimitri Gourdon wrote:
Hi all,
I have some servers with MySQL databases. I want to know what is the
best way to backup these databases ?
For now, i think i will do mysqldump on each server to local disk and
after
16 matches
Mail list logo