I forgot to mention, I also backup a few other files/folder critical to RT:
###################################### # BACKUP DATABASES # ###################################### mysqldump -u root rt3 > rt3_backup.sql mysqldump -u root mysql > mysql_backup.sql #mysqldump -u root information_schema > information_schema_backup.sql ###################################### # COPY OTHER FILES/FOLDERS # ###################################### cp /etc/aliases /opt/rt3/lib/RT/rt-backup/ cp /etc/apache2/httpd.conf /opt/rt3/lib/RT/rt-backup/ cp /opt/rt3/etc/RT_SiteConfig.pm /opt/rt3/lib/RT/rt-backup/ cp -r /opt/rt3/local/ /opt/rt3/lib/RT/rt-backup/ This way I have a copy of my e-mail addresses for my queues, my apache config, my SiteConfig, and my whole local folder.... -- Max McGrath Asst. Network Admin/Systems Specialist Carthage College 262-552-5512 [email protected] On Wed, Jan 5, 2011 at 6:45 AM, Andy Graybeal <[email protected]>wrote: > This is exactly what I do. Is this a decent way to be doing it -- I've >> always just assumed it was okay. I do it hourly, and then SCP it to >> another system. >> >> Should I be stopping mysql or anything before doing the mysqldump? >> -- >> > > Max, > What made you do hourly dumps? I'm thinking now instead of nightly, I > should be doing hourly dumps like you. > > -Andy >
