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@randomtraveller.org.uk>
To: Justin Smith <justin@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
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
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@randomtraveller.org.uk>
To: Justin Smith <justin@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
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org