<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<br>
<br>
Hi Mike!<br>
<br>
<br>
<blockquote type="cite">
<div class="moz-text-flowed" style="font-family: -moz-fixed;
font-size: 12px;" lang="x-unicode">And last but not least,
Steve:<br>
<blockquote type="cite" style="color: #993399;">
<blockquote type="cite" style="color: #993399;">
<blockquote type="cite" style="color: #993399;">
<blockquote type="cite" style="color: #993399;">
<blockquote type="cite" style="color: #993399;">
<blockquote type="cite" style="color: #993399;">delete
* from settings where hostname='savaidh'
<br>
</blockquote>
</blockquote>
</blockquote>
Should probably just be delete from, not delete * from.
Also, check that
<br>
your copy and paste hasn't introduced "smart quotes". They
need to be the
<br>
simple "tick" quote that you get from the keyboard, not
some fancy-looking
<br>
alternative. Some programs (MS Word for one, probably
others as well) will
<br>
change these for you so they look better in documents, but
play havoc with
<br>
scripts <span class="moz-smiley-s1" title=":-)"></span>
<br>
</blockquote>
Yes, Mark and Mike are both right, I think it should be:
<br>
<br>
use mythconverg;
<br>
delete from settings where hostname='savaidh';
<br>
source savaidh.sql
<br>
quit
<br>
<br>
Sorry about that - I was unable to easily test those
commands as I did
<br>
not want to mess up my database.
<br>
</blockquote>
<br>
<chuckle> I don't blame you! I'm trying to double and
triple-check before I do anything! <span
class="moz-smiley-s1" title=":)"></span>
<br>
<br>
So:
<br>
mysql -u mythtv -p
<br>
user = mythtv and then it wants mythtv's password -- not an
absolute newbie! <g>
<br>
<br>
At the mysql prompt: use mythconverge;
<br>
Ah poop: "ERROR 1044 (42000): Access denied for user
'mythtv'@'%' to database 'mythconverge'
<br>
<br>
Trying sudo use mythconverge; 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>
</blockquote>
That one's easy: no 'e' on the end of the database name!
<br>
</div>
</blockquote>
<br>
Oops! I think that was my auto spell check kicking in when I
typed! Think the mysql was complaining about sudo anyway<br>
<br>
<br>
<br>
<blockquote type="cite">
<div class="moz-text-flowed" style="font-family: -moz-fixed;
font-size: 12px;" lang="x-unicode">
Alternatively you can select the database by adding it as the
last entry on the command line:
<br>
<br>
mysql -u mythtv -p mythconverg
<br>
<br>
- this does <b class="moz-txt-star"><span class="moz-txt-tag">*</span>not<span
class="moz-txt-tag">*</span></b> mean that it uses
mythconverg as the password!
<br>
</div>
</blockquote>
<br>
Hmm, yes! Part of me is dying to ask how does the
complier/whatever know when something is a variable. ...Or maybe
'mythtv' isn't the -u variable.... And the other part is now even
more confused!!<br>
<br>
</body>
</html>