[mythtv-users] importing existing recorded programs

[backuppc at sundquist.imapmail.org]

On Tue, 29 Dec 2009 19:22:27 -0500, backuppc at sundquist.imapmail.org
said:

> user at mythtv:~$ sudo /usr/share/mythtv/mythconverg_restore.pl
> --create-database --directory /mnt/sdb2/mythtv/ --filename
> mythconverg-1214-20091229180321.sql.gz
> 
> I got 
> 
> ERROR: Invalid database information file, stopped at
> /usr/share/mythtv/mythconverg_restore.pl line 686.

OK, I now realize I needed to provide path to mc.sql after the
--create-database option, but adding in that path just gave me 

mysql output:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
password: YES)

Unable to create initial database, stopped at
/usr/share/mythtv/mythconverg_restore.pl line 954.

...as expected based upon the mythconverg_restore.pl  documentation.

I actually had tried running the script without the --create-database
option at first and I got:

ERROR: The database does not exist.

But the database does exist:

user at mythtv:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 164
Server version: 5.1.37-1ubuntu5 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use mythconverg
Database changed
mysql>

Reading through the archives, and trying the tricks at
http://www.gossamer-threads.com/lists/mythtv/users/360360, I get this
additional info:

user at mythtv:~$ sudo perl /usr/share/mythtv/mythconverg_restore.pl
--username=root --verbose --directory /mnt/sdb2/mythtv/  --filename
mythconverg-1214-20091229180321.sql.gz                                   

Configuring environment:
  -    username: root   
  -        HOME: /home/jsundqui
  - MYTHCONFDIR: /home/jsundqui/.mythtv

Parsing configuration files:
  - checking: /home/jsundqui/.mythtv/config.xml
     parsing: /home/jsundqui/.mythtv/config.xml
  - checking: /home/jsundqui/.mythtv/backuprc  
     parsing: /home/jsundqui/.mythtv/backuprc  

Applying command-line arguments.

Checking configuration.

Database Information:
         DBHostName: localhost
             DBPort: 0
         DBUserName: root
         DBPassword: XXX
             DBName: mythconverg
        DBSchemaVer:
  DBBackupDirectory: /mnt/sdb2/mythtv/
   DBBackupFilename: mythconverg-1214-20091229180321.sql.gz
    create_database:

Executables:
       mysql_client: mysql
         uncompress: gzip -d

Miscellaneous:
    partial_restore: no
   restore_xmltvids: no
    change_hostname: no

Checking database.
Unable to connect to database.

ERROR: The database does not exist.
user at mythtv:~$


So I am still stuck.

Jon S.