On Thu, Feb 10, 2005 at 11:53:34PM -0800, Yan-Fa Li wrote: > Chris Petersen wrote: > >> Is there a sql database update that will take place when going from > >> 0.16 -> 0.17? I know they're done automatically, was just wondering if > >> the db changed... > > > > > > You can almost guarantee that a new release will have db changes (to > > update the version tag if nothing else -- it often gets bumped several > > times between releases). So yes, plenty of changes. > > > > If in doubt, mysqldump the db before doing the upgrade. > > mysqldump -umythtv -pmythtv -hlocalhost mythconverg | bzip2 -9 > > mythtv16.backup.bz2
The heck with "if in doubt": DO THIS. Even if you only upgrade at new-release time, make this step a standard part of your upgrade process. If you maintain documentation explaining to people how to do upgrades, please make this step part of your instructions. IF YOU HAVE TO ROLLBACK, AND YOU DIDN'T DO THIS, YOU WILL HATE YOURSELF. This has been a recording. :-) Cheers, -- jra -- Jay R. Ashworth [EMAIL PROTECTED] Designer Baylink RFC 2100 Ashworth & Associates The Things I Think '87 e24 St Petersburg FL USA http://baylink.pitas.com +1 727 647 1274 If you can read this... thank a system adminstrator. Or two. --me
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
