[mythtv-users] Problem with mc.sql and database upgrading
pez at cus.org.uk
Thu Oct 7 18:52:12 UTC 2004
Sorry about the double post, but it got lost inside another thread before.
I finaly decided to start again as I have been failing to get live tv or
recording to work so I deleted the database as in the instructions:
mysql> drop database mythconverg;
$ mysql -u root < mc.sql
but now when I run ./setup I get the following error:
2004-10-06 22:48:30 Inserting MythTV initial database information.
2004-10-06 22:48:30 Upgrading to schema version 1003
DB Error (Performing database upgrade):
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/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mysql.proc' doesn't exist
I tried it with the 0.15 mc.sql but get the same problem.
More information about the mythtv-users