title: How to duplicate a schema in mysql database
body: <h1>Target</h1>
  <p>Duplicate a schema in mysql database, without dumping sql files and execute them.</p>
  <p>It would be great if there is a way to accomplish this task in a few commands.</p>
  <h1>Background</h1>
  <p>There are ways to dump an database and import it by executing the sqls generated by an dump program.</p>
  <p>But what I would like to do is to execute an command like <code>copy schema abc to abc_bk</code>, and done.</p>
  <p>Because I have to do it through phpmyadmin and dumping all fields and re-import them is too time consuming.</p>