[mythtv-users] Migrating mysql to another server

[David]

Minh Duong wrote:

>My frontend/backend system is somewhat underpowered so
>I was wondering if anybody has mysql running on a
>machine that isn't the frontend or backend.  It
>appears that I have to:
>1)  Get mysql running on another machine
>2)  Copy the mysql tables from my current machine
>3)  Edit mysql.txt in on my current machine to point
>to my new machine.
>4)  Stop mysqld on my current machine?
>
>First how do I copy/restore my current data? 
>
do a
 man mysqldump

there's a one-liner in there in the 'examples' section...

David