[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