[mythtv-users] DB Backup Issues

[Chuck Peters]

On Mon, Apr 23, 2012 at 6:39 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 04/23/2012 06:22 AM, Chuck Peters wrote:
>>
>> I was about to upgrade my Ubuntu 10.04 Mythtv backend to .25 and manually
>> running the mythconverg_backup.pl isn't working. The script says access
>> denied, but I haven't changed the password and everything else appears to
>> be working.  The frontends all work, and I had an old file saved from
>> 2009-03-19 that shows the same mythconverg_backup.pl --verbose command
>> working.  If I run the backup via mysqldump without the username and host
>> parameters it seems to work fine.  I am running a bind server with a lan
>> zone and the error message shows the hostname io.lan rather than the IP,
>> could this be the cause?
>>
>> I would like to get this cleared up before I upgrade the Mythtv. Any
>> suggestions?
>>
>
> First step I'd recommend is to verify your DB password/connection
> information in ~/.mythtv/backuprc .

Yes I did that. At least according to the wiki page the backuprc only
needs to contain the DBBackupDirectory.  See
http://www.mythtv.org/wiki/Database_Backup_and_Restore
root at io:~# cat .mythtv/backuprc
DBBackupDirectory=/home/mythtv
root at io:~# cat .mythtv/config.xml
<Configuration>
  <UPnP>
    <MythFrontend>
      <DefaultBackend>
        <DBHostName>192.168.2.3</DBHostName>
        <DBUserName>mythtv</DBUserName>
        <DBPassword>correctpassword</DBPassword>
        <DBName>mythconverg</DBName>
        <DBPort>0</DBPort>
      </DefaultBackend>
    </MythFrontend>
  </UPnP>
</Configuration>


And to add another point to hopefully solve this issue, the
mythconverg_backup.pl works from one of the frontends.

cp at o32:~$ perl /usr/share/mythtv/mythconverg_backup.pl --verbose

Configuring environment:
  -    username: cp
  -        HOME: /home/cp
  - MYTHCONFDIR: /home/cp/.mythtv

Parsing configuration files:
  - checking: /home/cp/.mythtv/config.xml
     parsing: /home/cp/.mythtv/config.xml
  - checking: /home/cp/.mythtv/backuprc
     parsing: /home/cp/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

No DBSchemaVer specified, querying database.
Found DBSchemaVer: 1264.

Database Information:
         DBHostName: 192.168.2.3
             DBPort: 0
         DBUserName: mythtv
         DBPassword: XXX
             DBName: mythconverg
        DBSchemaVer: 1264
  DBBackupDirectory: /tmp
   DBBackupFilename: mythconverg-1264-20120423070542.sql

Executables:
          mysqldump: mysqldump
           compress: gzip

Attempting to use supplied password for mysqldump.
Any [client] or [mysqldump] password specified in the MySQL options file will
take precedence.

Executing command:
'/usr/bin/mysqldump' --defaults-extra-file='/tmp/ZTPmGxHonL'
--host='192.168.2.3' --user='mythtv' --add-drop-table --add-locks
--allow-keywords --complete-insert --extended-insert --lock-tables
--no-create-db --quick --add-drop-table 'mythconverg' 2>&1
1>'/tmp/mythconverg-1264-20120423070542.sql'

mysqldump exited with status: 0

Attempting to compress backup file.
 - Compressing backup file with IO::Compress::Gzip.

Successfully compressed backup to file:
/tmp/mythconverg-1264-20120423070542.sql.gz

Rotating backups.

Searching for files matching pattern:
/tmp/mythconverg-????-??????????????.sql*
 - Found 1 matching files.

Deleting 0 and keeping (up to) 5 backup files.
 - Keeping backup file: /tmp/mythconverg-1264-20120423070542.sql.gz


Thanks,
Chuck