Run a MySql Script from Command Line in Windows
Locate MySql.exe. It’s probably here:
c:\mysql\bin\
Open a command prompt and type:
c:\mysql\bin\mysql.exe -h [database] -u [username] -p [scriptpath] --force
The –force switch ignores all errors the script may run into. When you press enter, you’ll be asked for a password. Enter the password and your script will start running.
