[mythtv-users] Trying to recover from crash

[James Pifer]

On Fri, 2004-11-12 at 09:22, James Pifer wrote:
> Hi. I'm trying to recover from a crashed system. Thankfully I have a
> mysql backup and all my recordings were on another drive. So, right now
> I have the system rebuilt and ready to go. I think my problem is
> granting the proper rights in the DB for the mythtv user. 
> 
> Here's what I did. 
> 
> Connected to mysql as root
> mysql> create database mythconverg
> mysql> connect mythconverg
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Connection id:    10
> Current database: mythconverg
> 
> mysql> GRANT ALL PRIVILEGES ON mythconverg TO 'mythtv'@'localhost'
> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
> Query OK, 0 rows affected (0.01 sec)
> 
> Now if I try to import my backup using the mythtv user I get:
> [root at mythtv backup]#  mysql -u mythtv -pmythtv mythconverg <
> mythtv_backup.sql
> ERROR 1142 at line 11: create command denied to user: 'mythtv at localhost'
> for table 'callsignnetworkmap'
> [root at mythtv backup]# 
> 
> Or if I try to start mythbackend I get this in the log:
> 2004-11-12 09:16:31 Inserting MythTV initial database information.
> 2004-11-12 09:16:31 Upgrading to schema version 1003
> DB Error (Performing database upgrade):
> Query was:
> CREATE TABLE IF NOT EXISTS recordingprofiles(    id INT UNSIGNED
> AUTO_INCREMENT NOT NULL PRIMARY KEY,    name VARCHAR(128),    videocodec
> VARCHAR(128),    audiocodec VARCHAR(128),    UNIQUE(name));
> Driver error was [2/1142]:
> QMYSQL3: Unable to execute query
> Database error was:
> create command denied to user: 'mythtv at localhost' for table
> 'recordingprofiles'
> 
> What am I missing on this? Is there something else I should do first to
> setup the database?
> 
> My installation is on Redhat 9 using apt for the installation of ivtv
> and mythtv-suite. 
> 
> Any help is appreciated. 
> James
> 
> 
> ______________________________________________________________________
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Got this resolved. Sorry for the bother. 

Thanks,
James