[mythtv-users] REMINDER: Back Up Your Database.

[Michael T. Dean]

On 01/02/2014 09:53 AM, Karl Newman wrote:
> On Thu, Jan 2, 2014 at 6:31 AM, Jeff Breitner wrote:
>
>> On Wed, Jan 1, 2014 at 6:20 PM, Mike McMullin wrote:
>>
>>>    Deciding to force a backup just in case, I found out that I no longer
>>> have the mythconverg_backup.pl for 0.27.  Any ideas as to where this can
>>> be dl'ed from?
>>>
>>>
>> You can always try this:
>>
>> #!/bin/bash
>> time=`date +"%m%d%Y%H%M"`
>> mysqldump -u root --password=<password>  mythconverg>
>> /var/lib/mythconverge-$time.dump
>>
>> No, please don't do this. mythconverg_backup.pl uses specific
> command-line arguments to mysqldump to prevent a corrupted backup (or
> restore). That's why the script was created--for a reliable, supported
> method of backup and restore.

Exactly.  The given mysqldump command line /will/ create a backup with a 
corrupt schema, so if you ever restored that backup, you will have a 
corrupt schema (which could break functionality of the running system 
and/or prevent proper upgrades of the database in the future).

Mike