How to Backup Red Hat Enterprise Linux Apache & MySQL in a Wintel environment
 

Hi,

I've recently been given the task of backing up my company's Apache website and MYSQL DBs. We're using Microsoft DPM 2012 for all our windows servers, but currently do not have anything in place for MYSQL or Apache.

I'm looking for advice on how I can backup MYSQL and Apache - preferably with a DPM agent, but failing this, then may be just schedule backup jobs to a Samba or NFS share and get DPM to backup the share.

Any advice is much appreciated.

Thanks

You could use systemimager or mondoarchive to take a full BMR (bare metal restore) image of your Linux system to ISO images, suitable for network booting/rebuild which would snapshot your system, but really isn't a 'backup' in a strict sense.

You could easily write a small script to do a mysqldump of your MySQL databases (and this can be done while the DB is running), and tar it and your Apache configs/pages/whatever into a single file. If that file is on a resource that DPM is backing up (you mention Samba/NFS), then you're all set. DPM should back that file up every day, and handle versioning/archival for you.

Thanks TBone,

Quick question - from what I've read samba (CIFs) and NFS would both work, but why would I want to use one over the over?

SMB is easier to setup, but NFS is more secure\flexible with Windows Server 2008 R2?