[mythtv-users] Long-postponed MySQL upgrades - pitfalls?

[Dale Pontius]

On 02/05/2012 08:21 PM, Gary Buhrmaster wrote:
> On Sun, Feb 5, 2012 at 17:04, Michael <mythtv at blandford.net> wrote:
> ....
>> Backup your /var/lib/mysql
> 
> I would consider doing a mysqldump here
> rather than just copying the binary files.
> It generates a dump that is compatible with
> (almost?) any version of mysql.  If you are
> following the recommended practices, you
> may already doing a mysqldump on a
> daily basis:
> 
> http://www.mythtv.org/wiki/Database_Backup_and_Restore
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
I already have daily backups on a cron job.  I'd first check to see if
anything has been recorded since the last backup, and perhaps do
another, just to get the very latest status.  At that point I'd also do
a binary backup.

Obviously this is to be done during a gap when nothing is due to be
recorded.

Thank you for the advice, I'll get to this in the next few days.
Dale Pontius