How to import SQL files using command line

import-sql-files-command-line.txt

We're using MySQL database and XAMPP as our web server. In this case, I'm using Windows 11.

If you are struggling on importing big files to your database and you are getting any messages related to time of execution exceed or memory limit was reached, 
try to use MySQL command line to help you get through it. 

First of all, go to you mysql bin folder. In my case, it is: 
- c:\xampp\mysql\bin.

And then you type: 
- mysql.exe -u root -p database_name < C:\path_to_file\my_database.sql.

If you want to import a .gz file, type it:
- zcat myfile.sql.gz | mysql -u root -ppassword mydb

You are going to enter your password and just have to wait afterwards until it's finished.