It's true backing up the database is very important, but using the above command it is needlessly difficult to roll it back
I use d mysqldump --opt --allow-keywords --all-databases -uroot > mysqldump-0.16.sql gzip mysqldump-0.16.sql Risto. On Friday 11 February 2005 08:10 am, Jay R. Ashworth wrote: > 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 -- Risto Treksler Elkhorn Lodge Banff, Alberta, Canada _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
