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.
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.