<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><br>
<br>
Hi Folks!<br>
<br>
Thanks for all the replies! LIS, I'm an amateur and learned a
long time ago it's sometimes better not to do something when
things go wrong and ask for assistance. So, yup, ran into
another problem. (Figured I'd try to post in my morning and
possibly get something to try in my evening. "My's" based on my
local time.)<br>
<br>
<br>
Will start with Mark only because his message came in first:<br>
</div>
<blockquote type="cite"
cite="mid:mailman.7.1510488002.1385.mythtv-users@mythtv.org">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">mysql -u mythtv -p
It will as for the password of the new backend database, then give you
a prompt waiting for SQL commands. Give it these commands (replacing
my frontend hostname with yours):
delete * from settings where hostname='savaidh';
source savaidh.sql
quit
</pre>
</blockquote>
<pre wrap="">How many command lines is the above supposed to be? If three, with just
</pre>
</blockquote>
<pre wrap="">
3. First line starts with delete. Second with source. Third with quit.
But you probably need to do "connect mythconverg;" before the first command.
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?</pre>
</blockquote>
<br>
Thanks -- was sort of figuring it was three lines based on the
<CR><LF> display/formatting on this end -- and just
noticed the "commands end with ; or \g" in Terminal. (Some of us
newbies get overwhelmed easily!)<br>
<br>
Others are stating to use "use mythconverge;" -- not sure if it's
the same.<br>
<br>
<br>
<br>
<br>
Mike:<br>
<br>
<blockquote type="cite"
cite="mid:mailman.7.1510488002.1385.mythtv-users@mythtv.org">
<blockquote type="cite">
<pre wrap="">delete * from settings where hostname='savaidh'
</pre>
</blockquote>
<pre wrap="">Should probably just be delete from, not delete * from. Also, check that
your copy and paste hasn't introduced "smart quotes". They need to be the
simple "tick" quote that you get from the keyboard, not some fancy-looking
alternative. Some programs (MS Word for one, probably others as well) will
change these for you so they look better in documents, but play havoc with
scripts :-)</pre>
</blockquote>
<br>
I was sort of wondering about that wildcard; just seemed a little
generic use.<br>
<br>
As for the copy and paste, I am extracting my thread to LibreOffice
documents just so I can doodle notes. Copied the instructions to a
file using gedit to open -- I think that removes the 'pretty'
characters.<br>
<br>
<br>
<br>
<br>
<br>
And last but not least, Steve:<br>
<br>
<blockquote type="cite"
cite="mid:mailman.7.1510488002.1385.mythtv-users@mythtv.org">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">delete * from settings where hostname='savaidh'
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">Should probably just be delete from, not delete * from. Also, check that
your copy and paste hasn't introduced "smart quotes". They need to be the
simple "tick" quote that you get from the keyboard, not some fancy-looking
alternative. Some programs (MS Word for one, probably others as well) will
change these for you so they look better in documents, but play havoc with
scripts :-)
</pre>
</blockquote>
<pre wrap="">
Yes, Mark and Mike are both right, I think it should be:
use mythconverg;
delete from settings where hostname='savaidh';
source savaidh.sql
quit
Sorry about that - I was unable to easily test those commands as I did
not want to mess up my database.</pre>
</blockquote>
<br>
<chuckle> I don't blame you! I'm trying to double and
triple-check before I do anything! :)<br>
<br>
So:<br>
<tt>mysql -u mythtv -p</tt><br>
user = mythtv and then it wants mythtv's password -- not an absolute
newbie! <g><br>
<br>
At the mysql prompt: <tt>use mythconverge;</tt><br>
Ah poop: "ERROR 1044 (42000): Access denied for user 'mythtv'@'%'
to database 'mythconverge'<br>
<br>
Trying <tt>sudo use mythconverge;</tt> gives "error 1064 (4200) -
error in syntax". (Well it sounded logical!)<br>
<br>
I'll post and wait for assistance before I screw things up too much!<br>
<br>
TIA!<br>
Barry<br>
<br>
<br>
</body>
</html>