[mythtv-users] dedicated database box

[Paul Woodward]

I highly recommend phpmyadmin, it makes exports, sql stuff very easy indeed. It requires a web server but it doesn't have to be on the same box. It's very well documented and very easy to set up.

Paul

> Quoting Jayson Garrell <kyi at kyi.sytes.net>:
> 
> > On Thu, 2004-02-19 at 10:02, Steven Cruysberghs wrote:
> > > have a look at /usr/share/mythtv/mysql.txt
> >
> > I just did that and it appears to work. I looked at that file already
> > and I guess I must have read the top line wrong. Like I said it's
> > working now, running mythfilldatabase again. Now for the $64 question...
> > Is there a way to import my old recording into the new database?
> Use mysqldump on the old database, something like:
> mysqldump -u mythtv -pmythtv mythconverg > mythconverg.dmp
> 
> There's an option that will add DROP TABLE commands to the dump, which will
> cause the dump to nuke any existing DB when it's reloaded.
> 
> To reload it:
> mysql -u mythtv -pmythtv mythconverg (on the new system)
> 
> Not sure how to specify a remote DB with the commandline clients...
> mythconverg at host???
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>