[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