Re: Backup Policy

2011-03-16 Thread Karen Abgarian
Interestingly, this page does not say anything about MySQL Enterprise Backups. On Mar 15, 2011, at 8:48 AM, a.sm...@ukgrid.net wrote: Hi, there is a lot of info on different backup methods here: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html For example, for incremental backu

Re: Backup Policy

2011-03-15 Thread Jim McNeely
You might want to look into replication (http://dev.mysql.com/doc/refman/5.5/en/replication.html). You can set up a replication slave to follow the master DB in real time, or offset by minutes, hours, days, or weeks, or whatever. That way you have a copy already served up waiting in the wings,

Re: Backup Policy

2011-03-15 Thread Wm Mussatto
On Tue, March 15, 2011 12:36, Joerg Bruehe wrote: > Hi! > > > Adarsh Sharma wrote: >> Dear all, >> >> Taking Backup is must needed task in Database Servers. [[...]] > > Correct. > >> >> We have options RAID, mylvmbackup , mysqldump. But it depends on the >> company requirement too. > > RAID is no b

Re: Backup Policy

2011-03-15 Thread Joerg Bruehe
Hi! Adarsh Sharma wrote: > Dear all, > > Taking Backup is must needed task in Database Servers. [[...]] Correct. > > We have options RAID, mylvmbackup , mysqldump. But it depends on the > company requirement too. RAID is no backup! A RAID system may give you protection against a single disk

Re: Backup Policy

2011-03-15 Thread Johan De Meersman
- Original Message - > From: "Krishna Chandra Prajapati" > > incremental backup using zamanda. I'm running Zmanda on about two dozen hosts, and it comes well-recommended. It doesn't do anything that you can't do yourself, but it's easy to set up, reports well and backs up in what are b

Re: Backup Policy

2011-03-15 Thread a . smith
Hi, there is a lot of info on different backup methods here: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html For example, for incremental backups see "Making Incremental Backups by Enabling the Binary Log", cheers Andy. -- MySQL General Mailing List For list archives: http:

Re: Backup Policy

2011-03-15 Thread Krishna Chandra Prajapati
xtrabackup, mysqlhotcopy for myisam, incremental backup using zamanda. Krishna On Tue, Mar 15, 2011 at 9:09 PM, petya wrote: > Hi, > > What storage engine are you using? > > Peter Boros > > On 03/15/2011 02:12 PM, Adarsh Sharma wrote: > >> Dear all, >> >> Taking Backup is must needed task in Da

Re: Backup Policy

2011-03-15 Thread petya
Hi, What storage engine are you using? Peter Boros On 03/15/2011 02:12 PM, Adarsh Sharma wrote: Dear all, Taking Backup is must needed task in Database Servers. I research a lot and find techniques to perform it in Mysql. We have options RAID, mylvmbackup , mysqldump. But it depends on the c

Backup Policy

2011-03-15 Thread Adarsh Sharma
Dear all, Taking Backup is must needed task in Database Servers. I research a lot and find techniques to perform it in Mysql. We have options RAID, mylvmbackup , mysqldump. But it depends on the company requirement too. We have a database of more than 250GB in mysql database & which is inc