[mythtv-users] importing existing recorded programs
backuppc at sundquist.imapmail.org
backuppc at sundquist.imapmail.org
Wed Dec 30 02:51:50 UTC 2009
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.
More information about the mythtv-users
mailing list