evgv/sql_cli_db_import.md

Created April 7, 2016 15:12

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/evgv/adcb4eaa731de0affeea421c149ac8c8.js"></script>
Save evgv/adcb4eaa731de0affeea421c149ac8c8 to your computer and use it in GitHub Desktop.

SQL. Cli db import.

Raw

      // Import sql file
  mysql -h HOST --port=3307 -p -u  USER DATABASE < FILE
  
  // example
  mysql -h localhost --port=3307 -p -u root main < main_dump.sql
  
  // Import archive
  gunzip < FILE | mysql -h HOST --port=3307 -p -u USER DATABASE
  
  // example
  gunzip < main_dump.gz | mysql -h localhost --port=3307 -p -u root main