<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div style="color: black;">
<p style="margin: 0 0 1em 0; color: black; font-family: sans-serif;">On 12 November 2017 7:37:44 am Barry Martin <barry3martin@gmail.com> wrote:</p>
<p style="margin: 0 0 1em 0; color: black; font-family: sans-serif;">> Hi Steve!<br>
><br>
> Thanks for the detailed instructions -- have been experimenting when <br>
> have the time and a slot when the Backends aren't in use. So far each <br>
> time I have a question I get to a point I need help trying to put my <br>
> question into words and it dawns on me what is wrong and I can go on. <br>
> So, that's the reason for the delay in responding.<br>
><br>
><br>
>> Each frontend will be creating settings for itself on the new backend<br>
>> the first time it connects to it. So its settings on the new backend<br>
>> will be the defaults plus any changes you have done since then. In<br>
>> order to work out whether the frontend settings or the backend are the<br>
>> problem, it would be useful to copy the settings for a frontend from<br>
>> the old backend to the new backend. It is possible to do that as long<br>
>> as the databases are running the same database schema. I have not<br>
>> been following this thread in detail, so I am unsure if both the<br>
>> backends are running the same MythTV version. If they are, then the<br>
>> following procedure should do that.<br>
>><br>
>> This command should make a copy of the settings for a frontend on the<br>
>> old backend:<br>
>><br>
>> mysqldump -u mythtv -p --no-create-info mythconverg settings<br>
>> --where="hostname='savaidh'" >savaidh.sql<br>
><br>
> Stupid amateur mistake #1: knew this was one line, took me a few tries <br>
> to figure out there was a space between "settings" and "--where"! Used <br>
> find-and-replace to swap in your 'savaidh' with my 'T61' (I'm not all <br>
> that original when it comes to naming the computers!).<br>
><br>
> The Lenovo T61 laptop was configured to connect to BE2 -- the backend <br>
> I'm having issues with the sluggish Fast Forwarding. In my case that's <br>
> the "T61_backup.sql" (next step). Originally semi-sort-of did it wrong <br>
> because I got confused. Again, me and not you.<br>
><br>
> So created the T61.sql on BE1 (the 'good' backend) this morning. ....<br>
><br>
><br>
>> mysql -u mythtv -p<br>
>><br>
>> It will as for the password of the new backend database, then give you<br>
>> a prompt waiting for SQL commands. Give it these commands (replacing<br>
>> my frontend hostname with yours):<br>
>><br>
>> delete * from settings where hostname='savaidh';<br>
>> source savaidh.sql<br>
>> quit<br>
><br>
> How many command lines is the above supposed to be? If three, with just <br>
</p>
<p style="margin: 0 0 1em 0; color: black;"></p>
<p style="margin: 0 0 1em 0; color: black;">3. First line starts with delete. Second with source. Third with quit.</p>
<p style="margin: 0 0 1em 0; color: black;">But you probably need to do "connect mythconverg;" before the first command.</p>
<p style="margin: 0 0 1em 0; color: black;">I haven't read the thread history carefully but I presume the source line will need the correct file name created in an earlier step and may also need the path to the sql file?</p>
</div>
</body>
</html>