[mythtv-users] Re: troubles with xmltv and mythfilldatabase

[Don Brett]

Just thought I'd add a little fuel to the fire.  Sql commands:

- To enter into the linux mysql client
#mysql -uroot -pyourpassword

or, using the mythtv user and password,

#mysql -umythtv -pmythtv

Once into the client:

- to display databases:
mysql>show databases:

- to switch to a particular database (in this case 'mythconverg'):
mysql>use mythconverg;

- to display all tables in a database:
mysql>show tables;

- to display all contents of all rows of a table (in this case, the
channel table):
mysql>select * from channel;

- to display only selected columns of a table (in this case chanid,
channum, and freqid from the channel table):
mysql>select chanid, channum, freqid from channel;


Or, you can get the MySql-Front query analyzer client.  It's allot more
useful.

http://www.mysql-front.com/

Have fun,
Don