[mythtv-users] importing existing recorded programs

[backuppc at sundquist.imapmail.org]

Mike said:

> Oh, and in case it wasn't clear, it's the content of the error message
> that's important.
>
> Now that you know you forgot to use the --directory and --filename
> arguments, you don't need to update your copy of mythconverg_restore.pl. :)

Mike:

Thanks for responding, but I think our e-mails are crossing.  I screwed
up somewhat in my original e-mail because my problem there was *not*
that I forgot the --directory and --filename options, but instead it was
because I forgot the argument for the --create-database option.

As I mentioned, correcting myself, adding in the path to mc.sql after
--create-database caused the (as predicted in the script documentation)
access denied error.  But since I had already created the blank database
anyway, I didn't need the --create-database option in the first place.

So now, I am stuck with the restore script not seeing the new empty
database:
 
On Tue, 29 Dec 2009 19:52:28 -0500, backuppc at sundquist.imapmail.org
said:

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