[mythtv-users] cannot open db

[Edward Wildgoose]

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
though)

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
problem...?


> 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)