Hi All, I am now working on a plan of what to backup from various servers that I have running I run Apache, so httpd.conf and /var/www/html I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and /opt/zimbra/db/ I run MySQL, so /etc/my.cnf and /var/lib/mysql Can I simply write a bash script to tar.gz these areas, scp them and put it in a cron job? Is there anything special that I have to do with MySQL since it is running? If helpful, I can take what I learn and update the Wiki if there is not already a procedure for doing these operations on it. -Jason
On 2/23/2010 5:48 PM, Slack-Moehrle wrote:> Hi All, > > I am now working on a plan of what to backup from various servers that I have running > > I run Apache, so httpd.conf and /var/www/html > > I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and /opt/zimbra/db/ > > I run MySQL, so /etc/my.cnf and /var/lib/mysql > > Can I simply write a bash script to tar.gz these areas, scp them and put it in a cron job? > > Is there anything special that I have to do with MySQL since it is running? > > If helpful, I can take what I learn and update the Wiki if there is not already a procedure for doing these operations on it.Whenever someone mentions backups, I always recommend backuppc because it will do a better job with less archive space than anything else. You can read about it here: http://backuppc.sourceforge.net/ and there is a packaged version in the epel repository. -- Les Mikesell lesmikesell at gmail.com
On Tue, Feb 23, 2010 at 03:48:24PM -0800, Slack-Moehrle wrote:> Hi All, > > I am now working on a plan of what to backup from various servers > that I have running > > I run Apache, so httpd.conf and /var/www/html > > I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and > /opt/zimbra/db/ > > I run MySQL, so /etc/my.cnf and /var/lib/mysqlMight not be a bad idea to back up all of /etc. I'm not familiar with Zimbra, so you should refer to their documentation to make sure just copying their "db" files is sufficient.> > Can I simply write a bash script to tar.gz these areas, scp them and > put it in a cron job?Sure.> Is there anything special that I have to do with MySQL since it is > running?I'd take a look at: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html mysqldump works pretty well in most cases.> > If helpful, I can take what I learn and update the Wiki if there is > not already a procedure for doing these operations on it. > > -JasonRay
Slack-Moehrle wrote:> Hi All, > > I am now working on a plan of what to backup from various servers that I have running > > I run Apache, so httpd.conf and /var/www/html > > I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and /opt/zimbra/db/ > > I run MySQL, so /etc/my.cnf and /var/lib/mysql > > Can I simply write a bash script to tar.gz these areas, scp them and put it in a cron job? > > Is there anything special that I have to do with MySQL since it is running? > >for centos apache, you'll want everything in /etc/httpd/... and, my websites other than the default one are generally in /home/someaccount/html as I dont like having /var get that big. for mysql, you'll want to do a dump of your databases, and backup that dumpfile, rather than backing up the filestore. the only safe way to do a file level backup of a database server's backing store is to stop the sql server, then back it up. I dunno anything about zimbra. you probably also want to backup your /home dirs
At Tue, 23 Feb 2010 15:48:24 -0800 (PST) CentOS mailing list <centos at centos.org> wrote:> > Hi All, > > I am now working on a plan of what to backup from various servers that I have running > > I run Apache, so httpd.conf and /var/www/html > > I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and /opt/zimbra/db/ > > I run MySQL, so /etc/my.cnf and /var/lib/mysql > > Can I simply write a bash script to tar.gz these areas, scp them and put it in a cron job? > > Is there anything special that I have to do with MySQL since it is running? > > If helpful, I can take what I learn and update the Wiki if there is not already a procedure for doing these operations on it.What *I'd* do, is have separate partitions for /, /var /opt and /home. And do a monthy full dump of each file system, weekly incremental dumps of /var and /opt, and daily or every other day incremental dumps of /home. It is probably iffy to get a meaningful dump of mysql's running database. It probably makes better sense to do a SQL dump -- 'man mysqldump'.> > -Jason > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > >-- Robert Heller -- 978-544-6933 Deepwoods Software -- Download the Model Railroad System http://www.deepsoft.com/ -- Binaries for Linux and MS-Windows heller at deepsoft.com -- http://www.deepsoft.com/ModelRailroadSystem/