Importing tables using MySQL Command Line on Windows IIS

Importing tables using MySQL Command Line on Windows IIS

For importing (and exporting) table bigger than around 2MB into and out of MySQL:

1. Open command prompt

2. Navigate to mysql directory (to find it start/run MySQL and see the path of MySQL)

3.  Run command below

import table in command line mysql