[mythtv-users] Removed program table from mysql

cythrault at gmail.com cythrault at gmail.com
Wed Apr 6 21:39:00 UTC 2005


On Apr 6, 2005 5:36 PM, cythrault at gmail.com <cythrault at gmail.com> wrote:
> On Apr 6, 2005 5:23 PM, Ola Nilsson <ola.nilsson.home at telia.com> wrote:
> > Hello,
> >
> > I'm not that good at SQL, so using webmin I tried to empty the
> > mythconverg.program table. Unfortunatly, I'm not that good at webmin
> > either, so I ended up delating the table. Running mythfilldatabase
> > again just complains about the missing table.
> >
> > How can I easiest recreate an empty program table? (Don't reply with
> > restore backup... it's not an option.)
> 
> Restore an empty program table? No can do -- manually. Run
> mythfillbase or whetever mean you have to get your EPG.
> 
> Tho, creating the table is another matter. :)
> 
> Run this:
>
> ... 
> 
> cyth
> 

For future reference, to delete the CONTENT of program:

mysql -u mythtv -pmythtv mythconverg -e "delete from program;"


More information about the mythtv-users mailing list