Breadcrumbs

Home Web Development Importing an SQL file in XAMPP MYSQL via command prompt
Importing an SQL file in XAMPP MYSQL via command prompt PDF Print E-mail
Written by Tom   

 

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]