How to Import Large SQL Files into MySQL Using Laragon

Hello friends in this tutorial we will learn step-by-step to import large SQL files into MySQL using Laragon. Generaly you can not import larage sql file directly into MySQL. Learn how to move your Large SQL file, create a database, import data, and check your tables.

If you are using Laragon on your C or D: drive, your MySQL or MariaDB files are usually under:

C:\laragon\bin\mysql\mysql-8.x.x\bin
D:\laragon\bin\mysql\mysql-8.x.x\bin

Here’s how to safely import a large demo.sql file (e.g., 500MB, 1GB, 10GB) into MySQL using Laragon:

Step 1: Move Your SQL File

Place your SQL file in an easy-to-access folder. Folder can be anywhere. For example:

D:\laragon\data\demo.sql

Step 2: Open Laragon Terminal

Just click on the terminal tab and this opens CMD or PowerShell already pointed to D:\laragon.

Step 3: Create Your MySQL Database (optional)

If you don’t already have a database, create one. if you have a database skip this step.

mysql -u root -p

Press Enter (Laragon’s default MySQL root user has no password). So you can remove -p if root user has no password.

Inside the MySQL shell, run:

CREATE DATABASE demo_db;
EXIT;

(Replace demo_db with your preferred database name.)

Step 4: Import Your SQL File into MySQL

Run this command in CMD:

mysql -u root demo_db < "D:\laragon\data\demo.sql"

1. root → MySQL user (default is root)

2. demo_db → Your database name

3. "D:\laragon\data\demo.sql" → Full path to your SQL file

Step 5: Verify the Import

Open MySQL shell again:

mysql -u root demo_db

Check your tables:

SHOW TABLES;

Now you should see all your tables successfully imported.