[mythtv-users] cannot open db

Joseph Jamieson jjamieson at futurefoundations.com
Thu Mar 27 17:00:09 UTC 2003

An alternative to installing apache with mod php and all that stuff, is
to install webmin.  If you haven't checked out Webmin, do it now, it's
great.  It's a perl-based web admin tool (uses it's own web server
thingy) that can use SSL, and has modules for almost anything you can
think of.

The MySQL module allows you to do lots of stuff to the server and/or
individual databases.

-----Original Message-----
From: Edward Wildgoose [mailto:edward.wildgoose at frmhedge.com] 
Sent: Thursday, March 27, 2003 9:58 AM
To: mythtv-users at snowman.net
Subject: Re: [mythtv-users] cannot open db

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
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
and start again.  Install myphpadmin to get a nice web based way of
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
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)

mythtv-users mailing list
mythtv-users at snowman.net

More information about the mythtv-users mailing list