[mythtv-users] Any Trick to Updating MySQL ?
Brett Lucey
brett at happykoala.com
Thu Oct 16 15:09:43 EDT 2003
Any Trick to Updating MySQL ?
If you are concerned about losing all of your data, you can dump the database to a text file.
/usr/local/mysql/bin/mysqldump mythconverg > mythconverg_backup.txt
To reimport that file (in the case of disaster), you'd just drop the database and pump the file back in:
/usr/local/mysql/bin/mysqladmin drop mythconverg
/usr/local/mysql/bin/mysql < mythconverg_backup.txt
Be very careful when dropping databases :) You may need to change the paths to reflect that of your mySQL installation.
-Brett
----- Original Message -----
From: Wood, Mike
To: 'mythtv-users'
Sent: Thursday, October 16, 2003 11:48 AM
Subject: [mythtv-users] Any Trick to Updating MySQL ?
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?
TIA,
Mike
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.
------------------------------------------------------------------------------
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20031016/db983f62/attachment.html
More information about the mythtv-users
mailing list