[mythtv-users] major db problem upgrading from 0.21-fixes to 0.22

[Audio Phile]

OK!  The problem was that I didn't add the --partial_restore switch to the last step.  Doing that fixed it and I can now use the 0.22 except that my mythvideo plugin now doesn't work.  The GUI tells me that mythtvideo plugin isn't configured but I don't see where I am able to do so.

$ ./mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-20100307062803.sql.gz --partial_restore --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: 0
         DBUserName: mythtv
         DBPassword: XXX
             DBName: mythconverg
        DBSchemaVer:
  DBBackupDirectory: /home/mythtv
   DBBackupFilename: mythconverg-1214-20100307062803.sql.gz
    create_database:

Executables:
       mysql_client: mysql
         uncompress: gzip -d

Miscellaneous:
    partial_restore: yes
   with_plugin_data: no
   restore_xmltvids: no
    change_hostname: no

Checking database.

Found 54 tables in the database.

Backup file is compressed.
 - Uncompressing backup file with IO::Uncompress::Gunzip.

Attempting to use supplied password for mysql command-line client.
Any [client] or [mysql] password specified in the MySQL options file will
take precedence.

Restoring partial backup with filter:
(40101 SET NAMES |^INSERT INTO \`?(oldrecorded|record|recorded|recordedmarkup|recordedprogram|recordedrating|recordedseek)\`? )

Executing command:
'mysql' --defaults-extra-file='/tmp/kUypOugWIw' --host='localhost' --user='mythtv' 'mythconverg'

mysql exited with status: 0

Restored 13 of 3383 lines.

Successfully restored backup.

--- On Sun, 3/7/10, Audio Phile <da_audiophile at yahoo.com> wrote:

> From: Audio Phile <da_audiophile at yahoo.com>
> Subject: Re: major db problem upgrading from 0.21-fixes to 0.22
> To: mythtv-users at mythtv.org
> Date: Sunday, March 7, 2010, 5:30 AM
> Thank you both for the advice.
> @mtdean - I attempted your procedure (http://www.gossamer-threads.com/lists/mythtv/users/406111#406111)
> but ran into trouble:
> 
> I can drop the db okay but I couldn't use your code with
> the echo << "EOF", I had to type out each step as
> shown:
> 
> $ mysql -umythtv -p mythconverg
> Enter password: 
> Reading table information for completion of table and
> column names
> You can turn off this feature to get a quicker startup with
> -A
> 
> Welcome to the MySQL monitor.  Commands end with ; or
> \g.
> Your MySQL connection id is 535
> Server version: 5.0.75 Source distribution
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the
> buffer.
> 
> mysql> DROP DATABASE IF EXISTS mythconverg;
> Query OK, 54 rows affected (0.01 sec)
> 
> mysql> CREATE DATABASE IF NOT EXISTS mythconverg; 
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET
> latin1; 
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> quit
> Bye
> 
> I can restore the blank one okay:
> [mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl
> --dir=$HOME --file=mythconverg-1214-blank.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
> 
> Applying command-line arguments.
> 
> Checking configuration.
> 
> Database Information:
>          DBHostName:
> localhost
>          
>    DBPort: 0
>          DBUserName: mythtv
>          DBPassword: XXX
>          
>    DBName: mythconverg
>         DBSchemaVer: 
>   DBBackupDirectory: /home/mythtv
>    DBBackupFilename:
> mythconverg-1214-blank.sql.gz
>     create_database: 
> 
> Executables:
>        mysql_client: mysql
>          uncompress: gzip -d
> 
> Miscellaneous:
>     partial_restore: no
>    restore_xmltvids: no
>     change_hostname: no
> 
> Checking database.
> 
> Found 0 tables in the database.
> 
> Backup file is compressed.
>  - Uncompressing backup file with IO::Uncompress::Gunzip.
> 
> Attempting to use supplied password for mysql command-line
> client.
> Any [client] or [mysql] password specified in the MySQL
> options file will
> take precedence.
> 
> Executing command:
> 'mysql' --defaults-extra-file='/tmp/RCfj5LUMX4'
> --host='localhost' --user='mythtv' 'mythconverg'
> 
> mysql exited with status: 0
> 
> Restored 1553 of 1553 lines.
> 
> Successfully restored backup.
> 
> But I can't restore my backup:
> 
> [mythtv at mythtv ~]$ /usr/share/mythtv/mythconverg_restore.pl
> --dir=$HOME --file=mythconverg-1215-20100306190349.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
> 
> Applying command-line arguments.
> 
> Checking configuration.
> 
> Database Information:
>          DBHostName:
> localhost
>          
>    DBPort: 0
>          DBUserName: mythtv
>          DBPassword: XXX
>          
>    DBName: mythconverg
>         DBSchemaVer: 
>   DBBackupDirectory: /home/mythtv
>    DBBackupFilename:
> mythconverg-1215-20100306190349.sql.gz
>     create_database: 
> 
> Executables:
>        mysql_client: mysql
>          uncompress: gzip -d
> 
> Miscellaneous:
>     partial_restore: no
>    restore_xmltvids: no
>     change_hostname: no
> 
> Checking database.
> 
> Found 54 tables in the database.
> WARNING: Database not empty.
> 
> ERROR: Unable to do a full restore. The database contains
> data.
> 
> Can you advise?