title: copy database structure without data in mysql (with empty tables)
body: <p>Is there any way to copy database structure without data in MySQL, so the new database will be the same as it is copied from, but with empty tables.</p>
  
  <p>After getting some suggestions I tried the command, but I am getting syntax error, my <code>username = root</code> and <code>password = nothing</code>. I guess the default one. I am trying following command, </p>
  
  <pre><code>mysqldump -u root -p -d xyz_db | mysql -u root -p -Dnew_db
  </code></pre>
  
  <p>what I am missing or misplacing in command?</p>