title: How to export and import a .sql file from command line with options?
body: <p><strong>Not Duplicate!</strong> looking for some feature have phpmyadmin during export in command line</p>
  
  <p>I want to export and import a .sql file to and from a MySQL database from <strong>command line</strong>.</p>
  
  <p>Is there any command to export .sql file in MySQL? Then how do I import it?</p>
  
  <p>When doing the export/import, there may be <strong>constraints</strong> like enable/disable <strong>foreign key check</strong> or <strong>export only table structure</strong>.</p>
  
  <p>Can we set those <strong>options</strong> with <code>mysqldump</code>?</p>
  
  <p><em>some example of Options</em></p>
  
  <p><a href="https://i.stack.imgur.com/qPu8g.png" rel="noreferrer"><img src="https://i.stack.imgur.com/qPu8g.png" alt="enter image description here"></a></p>