<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Any Trick to Updating MySQL ?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>If you are concerned about losing all of
your data, you can dump the database to a text file. </FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>
/usr/local/mysql/bin/mysqldump mythconverg >
mythconverg_backup.txt</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>To reimport that file (in the case of
disaster), you'd just drop the database and pump the file back in:</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>
/usr/local/mysql/bin/mysqladmin drop mythconverg</FONT></DIV>
<DIV><FONT face="Courier New" size=2>
/usr/local/mysql/bin/mysql < mythconverg_backup.txt</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Be very careful when dropping databases
:) You may need to change the paths to reflect that of your mySQL
installation.</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>-Brett</FONT></DIV>
<DIV><FONT face="Courier New" size=2></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=Mike.Wood@marriott.com href="mailto:Mike.Wood@marriott.com">Wood,
Mike</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=mythtv-users@mythtv.org
href="mailto:mythtv-users@mythtv.org">'mythtv-users'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, October 16, 2003 11:48
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [mythtv-users] Any Trick to
Updating MySQL ?</DIV>
<DIV><BR></DIV>
<P><FONT face=Arial size=2>Hey, I'm thinking about updating MySQL to version
4.0 so I can take advantage of some of the features. I'm running RH9
with MySQL version 3.23.56 today. Is there any big trick to updating
this from MythTV's perspective? I will backup the database before I
install 4.0, just to be safe, but otherwise, should the mythconverg just
work?</FONT></P>
<P><FONT face=Arial size=2>TIA,</FONT> <BR><FONT face=Arial size=2>Mike</FONT>
</P>
<P><FONT face="Times New Roman" color=#000080 size=1>This communication
contains information from Marriott International, Inc. that may be
confidential. Except for personal use by the intended recipient, or as
expressly authorized by the sender, any person who receives this information
is prohibited from disclosing, copying, distributing, and/or using it.
If you have received this communication in error, please immediately delete it
and all copies, and promptly notify the sender. Nothing in this communication
is intended to operate as an electronic signature under applicable
law.</FONT></P><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>mythtv-users mailing
list<BR>mythtv-users@mythtv.org<BR>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<BR></BLOCKQUOTE></BODY></HTML>