Importing an SQL file in XAMPP MYSQL via command prompt. You may need to do this if the sql file is too large. In excess of 500MB, I have imported a sql file of over 1GB.
Open CMD prompt
Navigate to xampp\mysql\bin
Access the MYSQL database with the command: mysql -u mkgrc1010 -p
[where -u: username -p: password you will be prompted to enter password]
Navigate to the empty database with the command: use databasename
Import the database file from file location. Find the file in windows explorer and copy the file path
Import using the command: source: C:\Users\Public\Documents\MochHost files\mysqlfilename.sql
[note to change the file path to frontslash]
