[mythtv-users] Screwed up display.

[clemens at dwf.com]

> On Jun 3, 2007, at 9:59 PM, Reg Clemens wrote:
> 
> >
> > I readily admit I am not a mysql person.
> >> From looking at it, it LOOKS like your statement will do exactly  
> >> what I want
> > to do, but when I execute it I get an error, viz
> >
> > ---
> >
> > (as root)
> > % mysql
> > mysql> DELETE FROM settings WHERE `hostname` = 'mythtv-fe.dwf.com';
> > ERROR 1046 (3D000): No database selected.
> >
> > ---
> >
> > So it looks like I either need to add something to this line, or add a
> > previous line
> > that selects a database (mythconverg?)
> >
> > Any additional help would really be appreciated, I dont want to  
> > have to
> > completely
> > rebuild this thing just for this one silly error.
> 
> 
> use mythconverg;
> 
> so mysql knows what database you're talking about before you delete  
> rows from a table.
> 
That gets rid of the error message, but the tables dont seem to get modified
(I tried the fully qualified name, the name, and the IP address just to cover 
all bases)

---

[root at mythtv ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 58 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mythconverg;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DELETE FROM settings WHERE `hostname` = 'mythtv-fe.dwf.com';
Query OK, 0 rows affected (0.02 sec)

mysql> DELETE FROM settings WHERE `hostname` = 'mythtv-fe';
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM settings WHERE `hostname` = '192.168.0.2';
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye
[reg at deneb ~]$ 

---

I stopped/restarted mysql, rebooted the remote machine, but things 
havent changed (sigh).

Any additional suggestions? 
I would have to assume that 'hostname'  or 'settings' is not the correct
variable name/table (or that I am doing something stupid)

-- 
                                        Reg.Clemens
                                        reg at dwf.com