[mythtv-users] dedicated database box

[Andrew Dodd]

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???