[mythtv-users] Backing up the mysql database

[Brian Wallen]

It still has the same result.  I get that stupid error message

mythtv ~ # mysqldump -c -u mythtv --password=mythtv mythconverg > 
mythtv_backup.sql
mysqldump: unknown option '--name-resolve'
mythtv ~ #


<BLOCKQUOTE style='PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #A0C6E5 
2px solid; MARGIN-RIGHT: 0px'><font 
style='FONT-SIZE:11px;FONT-FAMILY:tahoma,sans-serif'><hr color=#A0C6E5 
size=1>
From:  <i>chris at cpr.homelinux.net</i><br>Reply-To:  <i>Discussion about 
mythtv &lt;mythtv-users at mythtv.org&gt;</i><br>To:  <i>Discussion about 
mythtv &lt;mythtv-users at mythtv.org&gt;</i><br>Subject:  <i>Re: 
[mythtv-users] Backing up the mysql database</i><br>Date:  <i>Mon, 29 Aug 
2005 19:37:52 -0700</i><br>&gt;On Tue, Aug 30, 2005 at 12:54:58AM +0000, 
Brian Wallen wrote:<br>&gt; &gt; I'm moving backend servers, and I want to 
take my database with me.  I<br>&gt; &gt; looked at the documentation at 
mythtv.org and did what it told me, but I'm<br>&gt; &gt; getting an odd 
error. Can anyone help? Here is what I do.<br>&gt; &gt;<br>&gt; &gt; mythtv 
~ # mysqldump -u mythtv -pmythtv mythconverg -c &gt; 
mythtv_backup.sql<br>&gt; &gt; mysqldump: unknown option 
'--name-resolve'<br>&gt;<br>&gt;According to the mysqldump man page your 
command is formed incorrectly.<br>&gt;The options should all precede the 
database name and you can't specify a<br>&gt;password using the -p option.  
Try:<br>&gt;<br>&gt;mysqldump -c -u mythtv --password=mythtv mythconverg 
&gt; mythtv_backup.sql<br>&gt;or<br>&gt;mysqldump -c -u mythtv -p 
mythconverg &gt; mythtv_backup.sql<br>&gt;<br>&gt;In the second case 
mysqldump will prompt you for the password (which is<br>&gt;also more secure 
since it doesn't show in a ps listing).<br>&gt;<br>&gt;--<br>&gt;A: Because 
it messes up the order in which people normally read text.<br>&gt;Q: Why is 
top-posting such a bad thing?<br>&gt;A: Top-posting.<br>&gt;Q: What is the 
most annoying thing on usenet and in 
e-mail?<br><p>&gt;_______________________________________________<br>&gt;mythtv-users 
mailing 
list<br>&gt;mythtv-users at mythtv.org<br>&gt;http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users<br><p></font></BLOCKQUOTE>