[mythtv-users] mythfilldatabase howto?

[Teruel de Campo]

John Johnson wrote:
> On your MythTV box, try running:
> 
> ps ax | grep mysql

tdec at amd64:~> ps ax | grep mysql
  7256 pts/1    S      0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql
  7281 pts/1    Sl     0:00 /usr/sbin/mysqld --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/amd64.pid --skip-locking
--port=3306--socket=/var/lib/mysql/mysql.sock
11747 pts/2    S+     0:00 grep mysql


> nmap localhost

Thxs nice port scanner

tdec at amd64:~> nmap localhost

Starting nmap 3.75 ( http://www.insecure.org/nmap/ ) at 2005-01-16 20:22 MST
Interesting ports on localhost (127.0.0.1):
(The 1656 ports scanned but not shown below are in state: closed)
PORT     STATE SERVICE
22/tcp   open  ssh
25/tcp   open  smtp
111/tcp  open  rpcbind
631/tcp  open  ipp
3306/tcp open  mysql
6543/tcp open  mythtv
6544/tcp open  mythtv

Nmap run completed -- 1 IP address (1 host up) scanned in 0.202 seconds

> If so, try this:
> mysql -umythtv -pmythtv mythconverg
> 
> you should get a mysql> prompt.
> Try:
> 
> show tables;


mysql> show tables;
+----------------------------+
| Tables_in_mythconverg      |
+----------------------------+
| callsignnetworkmap         |
| capturecard                |
| cardinput                  |
| channel                    |
| codecparams                |
| conflictresolutionany      |
| conflictresolutionoverride |
| conflictresolutionsingle   |
| credits                    |
| dvb_channel                |
| dvb_pids                   |
| dvb_sat                    |
| dvb_signal_quality         |
| favorites                  |
| housekeeping               |
| jumppoints                 |
| keybindings                |
| keyword                    |
| mythlog                    |
| networkiconmap             |
| oldprogram                 |
| oldrecorded                |
| people                     |
| profilegroups              |
| program                    |
| programgenres              |
| programrating              |
| recgrouppassword           |
| record                     |
| recorded                   |
| recordedmarkup             |
| recordingprofiles          |
| recordoverride             |
| settings                   |
| transcoding                |
| videosource                |
+----------------------------+
36 rows in set (0.00 sec)


> That should be a decent start on troubleshooting the problem.

Thank you for everything. It seems everything is working ok. I was 
wondering why I can not do

# myth filldatabase

 From the reading I though that you could do it any time to refresh the 
table.
I'll keep this message and thxs much for all the tips.

All the best,

-=terry(Denver)=-