Re: [mythtv-users] Migrating mysql to another server
On 4/13/05, Minh Duong [EMAIL PROTECTED] wrote: First how do I copy/restore my current data? http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5 and there's all kinds of other good helpful info at http://www.mythtv.org Second, is it a good idea to use another machine? Thanks. No idea, I've never tried it. Did you search the mailing list archives? I'm pretty sure I've seen this discussed in the past. Brad ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Migrating mysql to another server
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 ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Migrating mysql to another server
I did it from the get-go that way, but what you have noted above is probably enough to work for a migration. You'll also need to re-run mythsetup and plug in the new values that are in mysql.txt You may also run into permissions problems, but I'm going to assume troubleshooting those won't be too hard, and if in the end you have problems that you can't google, post here and I'm sure a mysql geek can GRANT you the proper syntax. Cool On 4/13/05, Brad Benson [EMAIL PROTECTED] wrote: On 4/13/05, Minh Duong [EMAIL PROTECTED] wrote: First how do I copy/restore my current data? http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5 and there's all kinds of other good helpful info at http://www.mythtv.org Second, is it a good idea to use another machine? Thanks. No idea, I've never tried it. Did you search the mailing list archives? I'm pretty sure I've seen this discussed in the past. Brad ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Migrating mysql to another server
Oh, as for backing up/restoring: mysqldump mythconverg.sql -d mythconverg And then restoring on the new mysql machine: mysql mythconverg.sql -p Password: Check the man page for mysqldump to ensure my syntax is correct ;) Good Luck! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users