<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.2">
</HEAD>
<BODY>
I could swear I've used mysqlhotcopy for innodb in the past; but I could be mistaken.<BR>
<BR>
You could also add a read only slave off of one of your master dbs that you periodically take offline and backup.<BR>
<BR>
For that matter, you could also take one of your master dbs offline periodically and back it up; depending on how your using it. <BR>
<BR>
Clint<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="570">
<TR>
<TD COLSPAN="2">
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="570">
<TR>
<TD VALIGN="top">
<A HREF="http://web.twelvehorses.com/"><IMG SRC="http://web.twelvehorses.com/images/email/th_logo.gif" WIDTH="268" HEIGHT="80" ALIGN="bottom" ALT="Twelve Horses" BORDER="0"></A>
</TD>
<TD VALIGN="top">
<A HREF="http://web.twelvehorses.com/info_center/whitepaper/"><IMG SRC="http://web.twelvehorses.com/images/email/mobile.gif" WIDTH="84" HEIGHT="80" ALIGN="bottom" ALT="Mobile" BORDER="0"></A>
</TD>
<TD VALIGN="top">
<A HREF="http://web.twelvehorses.com/solutions/blogging_for_business/"><IMG SRC="http://web.twelvehorses.com/images/email/social.gif" WIDTH="83" HEIGHT="80" ALIGN="bottom" ALT="Social" BORDER="0"></A>
</TD>
<TD VALIGN="top">
<A HREF="http://web.twelvehorses.com/solutions/website_design/"><IMG SRC="http://web.twelvehorses.com/images/email/web.gif" WIDTH="79" HEIGHT="80" ALIGN="bottom" ALT="Web" BORDER="0"></A>
</TD>
<TD VALIGN="top">
<A HREF="http://web.twelvehorses.com/technology/"><IMG SRC="http://web.twelvehorses.com/images/email/email.gif" WIDTH="56" HEIGHT="80" ALIGN="bottom" ALT="Email" BORDER="0"></A>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD VALIGN="top">
<BR>
<B><FONT SIZE="2"><FONT COLOR="#333333">Clinton Goudie-Nice</FONT></FONT></B><BR>
<FONT SIZE="1"><FONT COLOR="#333333">Architect / Senior Software Engineer</FONT></FONT><BR>
<FONT SIZE="1"><FONT COLOR="#2d5ca8"><A HREF="mailto:cgoudie@twelvehorses.com">cgoudie@twelvehorses.com</A></FONT></FONT><BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">Phone:</FONT></FONT>
</TD>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">+1.801.571.2665 ext 3264</FONT></FONT>
</TD>
</TR>
<TR>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">Mobile:</FONT></FONT>
</TD>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">+1.801.915.0629</FONT></FONT>
</TD>
</TR>
<TR>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">Fax:</FONT></FONT>
</TD>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">+1.801.571.2669</FONT></FONT>
</TD>
</TR>
<TR>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333">LinkedIn:</FONT></FONT>
</TD>
<TD>
<FONT SIZE="1"><FONT COLOR="#333333"><A HREF="http://www.linkedin.com/in/cgoudie">http://www.linkedin.com/in/cgoudie</A></FONT></FONT>
</TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top">
<BR>
<B><FONT SIZE="2"><FONT COLOR="#333333">Twelve Horses</FONT></FONT></B><BR>
<FONT SIZE="1"><FONT COLOR="#333333">13961 Minuteman Drive</FONT></FONT><BR>
<FONT SIZE="1"><FONT COLOR="#333333">Suite 125</FONT></FONT><BR>
<FONT SIZE="1"><FONT COLOR="#333333">Draper, UT 84020</FONT></FONT><BR>
<B><FONT SIZE="1"><FONT COLOR="#2d5ca8"><A HREF="http://www.twelvehorses.com">www.twelvehorses.com</A></FONT></FONT></B>
</TD>
</TR>
</TABLE>
<BR>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<BR>
On Tue, 2008-04-15 at 12:29 +0200, Michael A. Toth wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Hi Ask,</FONT>
<FONT COLOR="#000000">On Tue, Apr 15, 2008 at 12:16 PM, Ask Bjørn Hansen <<A HREF="mailto:ask@develooper.com">ask@develooper.com</A>> wrote:</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> InnoDB.</FONT>
<FONT COLOR="#000000">Okay, thanks.</FONT>
<FONT COLOR="#000000">> Because it won't lock on a high number of queries. Because it's much</FONT>
<FONT COLOR="#000000">> harder to corrupt when the server crashes. Because it's much easier to use</FONT>
<FONT COLOR="#000000">> the resources the box provides. Because it is easier to backup.</FONT>
<FONT COLOR="#000000">I understand everything, except the latest. Easier to backup? How can</FONT>
<FONT COLOR="#000000">I backup easily a single 10+ GB data file? mysqlhotcopy works with</FONT>
<FONT COLOR="#000000">myisam tables only. innodbhotcopy is a commercial product. Should I</FONT>
<FONT COLOR="#000000">use LVM snapshot?</FONT>
<FONT COLOR="#000000">Thanks,</FONT>
<FONT COLOR="#000000">Michael</FONT>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>