[mythtvnz] Screwed up Settings table in Myth Database

[Nick Rout]

Trying to get what you want, but I keep getting an error:

mysqldump -h localhost -u mythtv -p --lines-terminated-by='\n'
--fields-terminated-by=',' --fields-optionally-enclosed-by='"'
--tab='/home/mythtv/'  mythconverg settings



On Feb 1, 2008 7:50 AM, Neil Henwood <nhenwood at gmail.com> wrote:
> Anyone.....
>
>
> Neil Henwood wrote:
> > Hi All.
> >
> > I've managed to screw things up properly this time. I was doing some
> > 'cleaning up' and was going to rename some old unneeded front ends
> > settings from the database before deleting them when I managed to screw
> > things up royally. (finding a ; before a where clause after executing a
> > update statement is not a good thing :( )
> >
> > I have most things working again, except my remote front end machine
> > which now wont connect to the database.
> >
> > Would it be possible for someone to email me CSV of there settings table
> > so that I can see what I need to do to fix my table to get this working
> > again.
> >
> > (I need to get it done before Friday before the GF comes around and
> > wants to use it)
> >
> > Thanks for your help in this.
> >
> > Neil
> >
> > _______________________________________________
> > mythtvnz mailing list
> > mythtvnz at lists.linuxnut.co.nz
> > http://lists.ourshack.com/mailman/listinfo/mythtvnz
> > Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
> >
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>