title: Mysql database backup by using query
body: <p>I wanna dump file for MySQL database using query.I got the dump file when i used shell.but i could not get dump file while using heidisql.</p>
  
  <p><strong>In Shell:</strong> </p>
  
  <pre><code>C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin&gt;
  mysqldump -uroot -proot &gt;"D:\backups\student.sql"
  </code></pre>
  
  <p><strong>In Heidisql:</strong></p>
  
  <ol>
  <li><p>C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqldump -u root -p root databases student >"D:\student.sql"</p></li>
  <li><p>mysqldump -u root -p[root] [student] > D:/student.sql</p></li>
  </ol>