[mythtv-users] Trying to recover from crash
jep at obrien-pifer.com
Fri Nov 12 17:19:54 UTC 2004
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 <
> 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
> 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.
> mythtv-users mailing list
> mythtv-users at mythtv.org
Got this resolved. Sorry for the bother.
More information about the mythtv-users