Import Big Database in MySQL on Windows Server 2016
Sometimes "MySQL" not work in CMD or Power Shell, such case you have missed adding PATH variable into the system. Just add your MySQL bin directory path to System Environment. After adding PATH, you need to restart your server because PATH didn't go live sometimes.
If you added PATh correctly go into Power Shell or CMD and type mysql. If any warning returns with mysql that means you added PATH correctly.
To connect your MySQL database, use command - mysql -u root -p
It will ask for your password, you can change username instead of root.
When it connected with MySQL database, you can view database by using command - SHOW DATABASES;
But to import a database you need to create an empty database first, you can create in by PHPMYADMIN or in Command mode as - CREATE DATABASE database;
Then you have select that empty database by using command - USE database;
When you have created new empty database you can start old import database into it by using command - SOURCE //YOUR SQL FILE Directory