[mythtv-users] Fwd: Problem with mythconverg_restore.pl

[Mike Perkins]

Blast! I'll never understand why Thunderbird changed the delivery options!

Copying to mailing list.


-------- Forwarded Message --------
Subject: Re: [mythtv-users] Problem with mythconverg_restore.pl
Date: Wed, 4 Aug 2021 19:21:13 +0100
From: Mike Perkins <mikep at randomtraveller.org.uk>
To: Justin Smith <justin at smithpolglase.com>

On 04/08/2021 18:46, Justin Smith wrote:
> Hi,
> 
> The main disk in my mythtv box died (root partition). The disk I used for
> all the mythtv recordings is fine, which also has the mythconverg backups
> (automatically created by mythtv). But I have no backup of the mysql data
> folders themselves.
> 
> I'm running 31-fixes on Ubuntu 20.04.
> 
> After setting up a new disk with Ubuntu 20.04, installing 31-fixes (which
> installs mysql), etc, I tried to run mythconverg_restore.pl. I get the
> following error:
> 
> $ /usr/share/mythtv/mythconverg_restore.pl --drop_database
> --create_database --name mythconverg --filename
> mythconverg-1361-20210801074136.sql.gz --verbose
> 
> Configuring environment:
>    -    username: mythtv
>    -        HOME: /home/mythtv
>    - MYTHCONFDIR: /home/mythtv/.mythtv
> 
> Parsing configuration files:
>    - checking: /home/mythtv/.mythtv/config.xml
>       parsing: /home/mythtv/.mythtv/config.xml
>    - checking: /home/mythtv/.mythtv/backuprc
>       parsing: /home/mythtv/.mythtv/backuprc
> 
> Applying command-line arguments.
> 
> Checking configuration.
> 
> Database Information:
>           DBHostName: localhost
>               DBPort: 3306
>           DBUserName: mythtv
>           DBPassword: XXX
>               DBName: mythconverg
>          DBSchemaVer:
>    DBBackupDirectory: /opt/mythtv/mythconverg_backups
>     DBBackupFilename: mythconverg-1361-20210801074136.sql.gz
>        drop_database: yes
>      create_database: yes
> 
> Executables:
>         mysql_client: mysql
>           uncompress: gzip -d
> 
> Miscellaneous:
>      partial_restore: no
>     restore_xmltvids: no
>      change_hostname: no
> 
> Checking database.
> 
> Preparing initial database.
> Dropping database.
> DBD::mysql::st execute failed: Schema directory './mythconverg/' does not
> exist at /usr/share/mythtv/mythconverg_restore.pl line 1052.
> 
> ERROR: Unable to drop database.
> Schema directory './mythconverg/' does not exist
> 
> Does anyone know where I have gone wrong?
> 
> 
> Thanks in advance,
> Justin.
> 
Well, you did specify "--drop-database" and you don't have one yet.

Fell down that hole myself in the past...

-- 

Mike Perkins