title: MySQL: Cloning a MySQL database on the same MySql instance
body: <p>I would like to write a script which copies my current database <code>sitedb1</code> to <code>sitedb2</code> on the same mysql database instance. I know I can dump the sitedb1 to a sql script:</p>
  
  <pre><code>mysqldump -u root -p sitedb1 &gt;~/db_name.sql
  </code></pre>
  
  <p>and then import it to <code>sitedb2</code>. 
  Is there an easier way, without dumping the first database to a sql file?</p>