[mythtv-users] Uprage a 18.1 mysqldump to 19

[Ronald Kohsman]

Solution for anyone who might care.

I had another suse box laying around with mysql 4.1 ...imported the 4.1dump.

Ran the following command.

shell> *mysqldump --create-options --compatible=mysql40 db_name > dump_file*

you can read the info from here

http://dev.mysql.com/doc/refman/4.1/en/downgrading-to-4-0.html

took the new downgraded dump to the KnoppMyth box with mysql 4.0

bingo up and running


On 12/20/06, Ronald Kohsman <ronald.kohsman at gmail.com> wrote:
>
> I have it narrowed down. You are going to love this.
>
> FC4 w/mysql 4.1 mysqldump'd
> new box
> Knoppmyth (for reasons easiest explained..pchdtv 5500) w/mysql 4.0
>
> I believe somewhere there is the problem...I would like to retrieve the
> info. About 1 year and over 600GB of tv shows stored...not enough time to
> watch.
>
> Looking for help...btw...KnoppMyth served its purpose for getting my 250,
> 350 and pchdtv 5500 all working with little trouble...but not liking the
> stripped down OS too much. Afraid to punch it around too much and break
> something and cause troubles.
>
> Thanks again.
>
>
>
> On 12/20/06, Kevin Kuphal <kuphal at dls.net> wrote:
> >
> > Ronald Kohsman wrote:
> > > If you mean mysql command line import....did that with no success.
> > > Error on CHARSET=latin1.
> > How you import the database is really a question for mysql.  I can only
> > suggest reading the documentation on mysql.com
> >
> > Kevin
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
>
>
> --
> Ronald Kohsman
> Secure Applications Group
> (614) 530-0911 Direct
> ronald.kohsman at gmail.com
>



-- 
Ronald Kohsman
Secure Applications Group
(614) 530-0911 Direct
ronald.kohsman at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20061221/1ca299e0/attachment.htm