[mythtv-users] Problem with mythconverg_restore.pl

[Justin Smith]

On Thu, 5 Aug 2021 at 02:21, Mike Perkins <mikep at randomtraveller.org.uk>
wrote:

> On 04/08/2021 18:46, Justin Smith wrote:
>> > $ /usr/share/mythtv/mythconverg_restore.pl --drop_database
>> > --create_database --name mythconverg --filename
>> > mythconverg-1361-20210801074136.sql.gz --verbose
>> <snip>
>> > 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?
>>
>

> Well, you did specify "--drop-database" and you don't have one yet.
>> Fell down that hole myself in the past...
>
>
But mysql tells me I do... Before I ran the restore command, I ran:
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mythconverg        |
+--------------------+
2 rows in set (0.01 sec)

The mythconverg database is automatically created when you install mythtv
(at least on Ubuntu).

Trying to delete the database manually returns:
mysql> drop database mythconverg;
ERROR 3679 (HY000): Schema directory './mythconverg/' does not exist

I found my problem: I mangled the mysql configuration I moved the mysql
database directory to a separate partition.

Thanks,
Justin.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210805/733063c1/attachment.htm>