[mythtv-users] Can't restore Database

[Michael T. Dean]

On 05/15/2012 12:48 AM, Bill Meek wrote:
> On 05/14/2012 10:53 PM, Greg wrote:
>> I was having problems with my setup so I decided to format and start 
>> over...Everything goes fine until I try to restore my database.. I have
>> restored many times in the past and never had an issue...
> ...
>> Database Information:
>> DBHostName:
>> DBPort: -1
>> DBUserName:
>> DBPassword:
>> DBName: mythconverg
>> DBSchemaVer:
>> DBBackupDirectory: /video4/db_backups
> ...
>> Any ideas??????
>
> Hi;
>
> With DBSchemaVer 1301, I believe you're running master with the new
> config.xml format.
>
> If so, the restore and backup scripts don't handle the new format yet.
>
> As a workaround, put this in the directory of the user running
> the restore/backup, adjusted for your system:
>
> someone at yourHost:~/.mythtv$ cat backuprc
>
> DBBackupDirectory=/video4/db_backups
> rotate=20
> DBHostName=localhost
> DBUserName=mythtv
> DBPassword=yourPassword
> DBName=mythconverg
> DBPort=3306
>
> You may also find that backups running out of cron are failing and need
> to add this in the respective user's .mythtv directory.
>
> Note that the schema won't be part of the filename.

Bill's advice is good advice, but I went ahead and pushed a change that 
will allow the backup/restore scripts to work properly with the new 
config.xml format.  The new versions of the scripts will still work with 
the old config.xml format, too.  Anyone who wants/needs the update can 
pull a copy of the new version as described in the 2nd paragraph at 
http://www.mythtv.org/wiki/Database_Backup_and_Restore .

Mike