z3ntu/import_sql_file.md

Created February 11, 2016 09:25

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

Instructions to import an SQL file into your mysql installation.

Raw

Instructions

Change directory to the directory of your .sql file cd <directory-of-sql-script>
Enter the mysql console C:\xampp\mysql\bin\mysql.exe -u root
Create the database create database schuldb;
Use the created database use schuldb;
Import the .sql file source schuldb.sql;
Exit out of the mysql console exit