<meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><i>I run a nightly dump as root:<br><br>
mysqldump --opt rt3 -u root -p > rt3.sql<br> (assuming the root user can perform that dump)<br><br>Then scp the file to another system.<br><br>Since the rest of the system doesn't change much, I don't bother with much of anything else. I have a snapshot of the whole system (my RTs are VMs under VirtualBox, so they're easy to backup (single file)).</i></span><div>
<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><i><br></i></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">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.</span></font></div>
<div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;"><br></span></font></div><div><font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse: collapse;">Should I be stopping mysql or anything before doing the mysqldump?<br clear="all">
</span></font>--<br>Max McGrath<br>Asst. Network Admin/Systems Specialist<br>Carthage College<br>262-552-5512<br><a href="mailto:mmcgrath@carthage.edu">mmcgrath@carthage.edu</a><br>
<br><br><div class="gmail_quote">On Tue, Jan 4, 2011 at 4:56 PM, Joseph Spenner <span dir="ltr"><<a href="mailto:joseph85750@yahoo.com">joseph85750@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div></div><div class="h5">--- On Tue, 1/4/11, Andy Graybeal <<a href="mailto:andy.graybeal@casanueva.com">andy.graybeal@casanueva.com</a>> wrote:<br>
<br>
<br>
> Greetings,<br>
> I need a recommendation for backing up RT.<br>
><br>
> I am planning on using a cron job to run mysqldump to dump<br>
> the db, then rsync the db and /etc/ conf files to a host<br>
> that runs a backup job every night to tape.<br>
><br>
> What do you guys do?<br>
><br>
<br>
</div></div>I run a nightly dump as root:<br>
<br>
mysqldump --opt rt3 -u root -p > rt3.sql<br>
(assuming the root user can perform that dump)<br>
<br>
Then scp the file to another system.<br>
<br>
Since the rest of the system doesn't change much, I don't bother with much of anything else. I have a snapshot of the whole system (my RTs are VMs under VirtualBox, so they're easy to backup (single file)).<br>
<br>
<br>
<br>
<br>
<br>
</blockquote></div><br></div>