title: Mysqldump: Can you change the name of the table you're inserting into?
body: <p>I am using <code>mysqldump</code> to transfer a table from one database to another.</p>
  
  <pre><code>mysqldump -h host -u user -p password -e --single-transaction --no-create- info --default-character-set=utf8 --complete-insert --result-file=thisisaresult db table
  </code></pre>
  
  <p>I was wondering, however, if there is a way to change the name of the table you insert into? For example, I'd like this to insert into <code>table_staging</code>, or something like that. Is this possible, or am I going to have to just use <code>sed</code>?</p>