[mythtv-users] cannot open db

Edward Wildgoose edward.wildgoose at frmhedge.com
Thu Mar 27 14:57:31 UTC 2003

Looks like you may have had a mythtv database there already?

I think if you insert the file with the -f flag then it ignores errors and
continues to the end? Something like
mysql -u root -pyourpassword < mc.sql

(is there a command line example in the docs?)

If you are still at square one, then I would blow away the current database
and start again.  Install myphpadmin to get a nice web based way of tweaking
your sql databases (requires that you have already got apache installed

Ed W

P.S. Actually re-reading the errors I suspect that you are not logged into
mysql as an admin user before running this script - this may be the real

> slackware9.0
> compiled from souce
> mysql running: output of making the database from ms.sql:
> mysql> source mc.sql
> Query OK, 1 row affected (0.00 sec)
> ERROR 1036: Table 'user' is read only
> Database changed
> Query OK, 0 rows affected (0.00 sec)

More information about the mythtv-users mailing list