[mythtv-users] Mythfilldatabase temporary tables do not exist (SOLVED)

[R. G. Newbury]

R. G. Newbury wrote:
> 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.
> 
> 
> Help! I've fallen down to 5 days of listings and I can't get that up!

Following up, I have now determined that the actual error is a 
permissions problem.

MFDB cannot *create* the temp tables due to an OS permission failure 
(error 13)....

At present, mysql creates temporary tables at (be default) /tmp.

/tmp is owned by root and mysql does not have permission to write.

Somehow the mythbox is *not* using the 'tmpdir=/tmp/mysql' line in 
my.cnf. (Probably a typo by the nut at the keyboard!)

Setting that line in my.cnf on this laptop, creating a /tmp/mysql 
directory, and setting mysql as the owner of that directory and 
restarting mysqld allows it to work.

So obviously, the mythtv box is 'myth-configured'....

Hope this helps someone else in the future.

The wiki will get an up-date too.

Geoff