title: MySQL backup and restore from command line
body: <p>I am using Command line to backup and restore MYSQL Database.
  Let use I m having a Database Data1 having Views and Procedures in it.
  When in <code>Cmd line</code>, I use <code>mysqldump</code> i.e </p>
  
  <pre><code>..&gt;bin&gt; mysqldump -u root -proot Data1 &gt; Datafile.mysql
  </code></pre>
  
  <p>When I use above Cmd, It creates a Backup file on bin Folder of Mysql with <code>Dtafile.mysql</code>
  Name.</p>
  
  <p>but the thing is it creates Back Up of Only Tables, Not Procedures.</p>
  
  <p>And when I m restoring it in a Blank Database "Data2"</p>
  
  <pre><code>..bin&gt; mysql - u root -proot Data2 &lt; Dataafile.mysql
  </code></pre>
  
  <p>What it does is, It creates all the Tables and Convert Views into Tables and No Procedures has been restored.</p>
  
  <p>Means I am not able to Restore my full database backup with All tables, views and Procedures.</p>
  
  <p>Can any of you guys help it..
  I would be extremely Thankfull.</p>