<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<STYLE>.hmmessage P {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-SIZE: 10pt; FONT-FAMILY: Verdana
}
</STYLE>
<META content="MSHTML 6.00.6000.16809" name=GENERATOR></HEAD>
<BODY class=hmmessage bgColor=#ffffff>
<DIV><FONT face=Arial>John,</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>From the command prompt use mysqldump. The following
command gives all options:</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>mysqldump --help</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>I think the simplest option that should get everything
would just be:</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>mysqldump -u kohaadmin -p******* koha
>koha.backup</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>where ******* is your password for the kohaadmin user in
mysql.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>The resulting file can be used with any koha mysql
database to re-create the database as it is now by:</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>mysql -u kohaadmin -p******* koha
<koha.backup</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>I hope this helps.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Ian</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=smith_me@live.com href="mailto:smith_me@live.com">john smith</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=koha@lists.katipo.co.nz
href="mailto:koha@lists.katipo.co.nz">koha team</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, February 23, 2009 9:01
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Koha] Backup of Koha 3</DIV>
<DIV><BR></DIV>Hi to all<BR> <BR>I have installed <STRONG>koha 3</STRONG>
on <STRONG>ubuntu 8.04</STRONG> and all of that ok but i need to know way to
talk <STRONG>Backup </STRONG>from data on mysql please if any body know way to
that send me steps because i need that.<BR> <BR>thnks<BR> <BR>John
Smith<BR><BR>
<HR>
check out the rest of the Windows Live™. More than mail–Windows Live™ goes way
beyond your inbox. <A href="http://www.microsoft.com/windows/windowslive/"
target=_new>More than messages</A>
<P>
<HR>
<P></P>_______________________________________________<BR>Koha mailing
list<BR>Koha@lists.katipo.co.nz<BR>http://lists.katipo.co.nz/mailman/listinfo/koha<BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.0.237 / Virus Database: 270.11.2/1965 - Release
Date: 02/21/09 15:36:00<BR></BLOCKQUOTE></BODY></HTML>