Thanks. I'm aware that it will do a backup, but I'd like to be sure. Who knows if the particulars of my system cause something to fail in just the wrong place. I hope the scripts are written well enough that if a backup fails, the delete/modify/overwrite the existing database part of the operation would be prevented from running, but you just never know. <br>
<br><div class="gmail_quote">On Wed, Mar 12, 2008 at 6:43 PM, Michael T. Dean <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="Wj3C7c">On 03/12/2008 06:27 PM, Josh White wrote:<br>
> I'm working to update my system to .21, and from what I gather, the first<br>
> step probably should be to backup the database of my current .20.2 setup.<br>
> Unfortunately, I seem to have a problem with gaining the rights to do this.<br>
> It seems my user or my password is wrong. I've researched my way to "<br>
> <a href="http://www.mythtv.org/wiki/index.php/Backup_your_database" target="_blank">http://www.mythtv.org/wiki/index.php/Backup_your_database</a>" and following the<br>
> instructions there (quoted below):<br>
><br>
><br>
> $ mysqldump -u<myth_user> -p --extended-insert --databases<br>
> <myth_db_name> > mythdatabase.bak<br>
> Password: <myth_password><br>
><br>
> So reading that, I assume <myth_user> should be replaced with the<br>
> "user" from the database configuration 1/2 screen, which is by default<br>
> "mythtv"<br>
> and <myth_password> should be replaced with my password from the<br>
> Database Configuration screen.<br>
> I also presume the <myth_db_name> should be whatever it's called in<br>
> the Database configuration screen (mythconverg, by default)<br>
><br>
> I've tried all these settings (several times) and I get:<br>
><br>
> "Got error: 1045: Access denied for user 'mythtv'@localhost'<br>
> --databases mythconverg > mythconverg.bak"<br>
><br>
> All of my frontends connect to my backend and work fine, so I'm sure<br>
> the user and passwords from the configuration screen work to grant<br>
> some level of access to the database...<br>
><br>
> What am I doing wrong? Any suggestions?<br>
><br>
> I'm running 20.2 on Ubuntu 7.10 (all standard repo packages).<br>
><br>
> Thanks in advance for any assistance!<br>
<br>
</div></div>You may need a -h<hostname> or -h127.0.0.1 , depending on how you've<br>
configured your privs. The same DBHostName used in the MythTV setup<br>
screens should work.<br>
<br>
Also, I'm not going to mention that Myth 0.21 will attempt to backup<br>
your DB before upgrading it just in case it fails to get a backup. You<br>
really /should/ do one manually yourself--as you're attempting to<br>
do--just in case.<br>
<br>
Mike<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</blockquote></div><br>