[mythtv-users] Mythfilldatabase temporary tables do not exist.

[R. G. Newbury]

I am stumped by this one.
Mythfilldatabase runs and produces temporary files in a 
/tmp/mythtv_xxxxxx  (ignoring the my.cnf "tmp=/tmp/mysql" directive ??)

But mfdb cannot record the data as the "dd_xxxxx" tables do not exist.

The actual error is of the form:

2007-12-05 09:22:45.023 Grab complete.  Actual data from Wed Dec 5 
05:00:00 2007 to Thu Dec 6 05:00:00 2007 (UTC)
2007-12-05 09:22:45.024 Main temp tables populated.
2007-12-05 09:22:45.024 Updating myth channels.
2007-12-05 09:22:45.025 DB Error (Truncating temporary table dd_v_station):
Query was:
TRUNCATE TABLE dd_v_station;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.dd_v_station' doesn't exist


MySQL error 1146 is 'Table doesn't exist'....so that does not help.

I cannot, with my limited programming knowledge of myth, see where mfdb 
does/doesn't do this....

The system is running SVN 14882. I had a schema error and ended up doing 
a mysqldump of the necessary tables (see the myth docs at chapter 23. 
Thanks Robert!), and a full install of this SVN, followed by a restore 
of the record, recorded, etc. tables. It did a schema upgrade to 1201.

Help! I've fallen down to 5 days of listings and I can't get that up!

Geoff